Share your Knowledge of Excel and help others!

Think you can assist answering some of the questions received at Excel Geek?  Then why not become a contributor to the website and help share your knowledge of Excel!  All help is gratefully received!

You don’t need to be an expert to answer questions.  If you’ve had experience of a particular problem and found a solution then share it with other people.

Below are some of the latest questions submitted to the site…

Thank you  :-)

INDEX Array problems

Hi AllI have a formula, that works! (Hooray!) But only with a manual entered INDEX array..The working formula …

Force action when data is entered

Hi there!   I made a detailed budget for a client of mine in which we keep track of hours spend. During the assignment I can image that some taks requires more hours than …

Sumproduct with Year

Hi! Sumproduct returns a blank cell when I use following formula in the year column =TEXT(A1,”YYYY”) It DOES recognise =TEXT(A1,”MMMM”) in the Month …

Here is offering

Good man! There is an interesting offers for you. http://bit.ly/2M2v0vBBy:

Calculating a conditional value across multiple worksheets

I am trying to create a formula but really struggling! I’ll attempt to describe what I’m trying to do: Worksheet1 A1 value “Apple” Look for same value in …

VBA Loop through excel Cells from Word Document and change text in Word Document

Hi I am Using This Macro I want to Loop through a Colomn of Sheet 2 of Excel Workbook Marketing.xls From C2 to C67 and I want to change the word in “ABC ELECTRICALS” …

Formula as Text Issue

Hello Sir/Madam, Im wondering if youd be able to AID me with an issue im having, im not even sure if there is a work around. Background i have been tasked with collating …

EXCEL FORMULA HELP

hOW DO I WRITE A FORMULA TO CALCULATE IN EXCEL C2  CELL   if B2 = X THAN PRINT X IF NOT THAN CALCULATE =SUM( B2*100)113 By:

Parts Price

Good Morning (from) Vietnam. I have a lengthy spreadsheet with parts prices. What I need is a formula that finds a range of amounts – for example, a part priced from .01 …

Changes historic of excel workbook

Hello I would like to see all historic change of a workbook or at least of a cell un excel I would like to see when the person did insert info ina cell and at which date/ time. …

Average of time

Hello – I have several employees that have mulitple cells showing how much time it took them to complete one task.  How can I get the average for that one employee from …

excel doubt

hello sir, i need to transfer data to other spreadsheet like name address city number email favourate colour etc now i want to create separate workbook for different cities along …

if funtion

I had face some problem if funtion what does mean and how to formula create…use a logical function to find out if each customer is eligible for a daily deal (Y) or not (N), …

Copying the sorted data and it’s relevant columns together in new columns

Hi everyone. Consider there are 3 columns. I want to sort the 3rd column, in a way that the sorted data of the 3rd column are now in the 4th column. I do this with the function …

Duplication in Multiple Sheets

Hello everyone, Here is my problem in short sentenses: – I am trying to find dublicates through 10 or more sheets on excel. – I want that if dublicate exists in all of …

http://www.rebeccabuscemi.com/hot-sale/nike-air-force-1-x-gucci

cheap nike air max 95 original white royal blue trainer sale ukclearance sale nike solarsoft shoes woven premium purplenike blue turbo black shoxpartynextdoor 3 album nike air …

PDF Combine

I pulled out a code from the net for Combining pdf files in a folder using excel macro and (Acrobat) my only problem is that for every folder the naming convention is different …

excel file

I HAVE AN EXCEL FILE. IN THIS EXCEL FILE VBA AND MACRO IS PROTECTED.WHEN I OPEN THIS FILE ANOTHER SYSTEM THISA FILE NOT OPEN. THIS FILE SHOWS “PLEASE ENABLE …

Button Copy Row to New Sheet

Hi All, I am looking to incorporate buttons into a billing sheet. Cells A4:O4 Contain the Data on the Data Entry Tab. I have inserted a button in P4. I am looking to click the …

vba edit help

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean) ‘Updateby Extendoffice 20160725 Cancel = True Target.Offset(1).EntireRow.Insert …

Deleted data in cell in pivot table

While Auto save was on I had accidently deleted data in my pivot table now its gone. How do I get my data back?   Thank you. By: