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  :-)

functions

Fill the “Needs contacting?” column with YES or NO taking into consideration that the customer needs to be PAST DUE (due date <today) and NOT be privileged. If …

excell help

I WANT TO GENERATE RECEIPT FOR HOME[RS.100] WHICH CONTAIN LAND[RS.60] AND CONSTRUCTION COST [RS.40]. WHEN I RECEIVE RS. BELOW 60 ,MENTION”LAND”,AND ABOVE 60 …

EXCEL FORMULAS

I HAVE A EXCEL SHEET LIKE THIS GIVEN BELOW                                   1/2/2018   …

Copying fields into other worksheets

I have 2 worksheets. One is just a templete of what i want to copy over from the other worksheet. The other worksheet has over 900 rows. i want to transfer each row onto one …

Formula required

  I am using Excel 2010 and could you please help me with the following request.   Suppose A1 to E1 each contains as follows:   A1 CAT  /  B1 DOG / …

VBA Find Sub

I need a VBA sub that will use the title of a sheet to find the matching text on another sheet and use that text as reference to retrieve other data in the same row.  This …

Partial multiply

I have a table of Occupancy ratio and prices for a hotel Column A     Column B Occupancy  Price 0-30%        100usd …

надувные кровати отзывы

ЧАСЫ НАПОЛЬНЫЕ http://workle.website/5n By:

Conditional formatting

Formula to confirm if a cell in an excel spreadsheet is colored with answer”yes or no”. By:

Multiple IF to work out sum in table

I am trying to creeate a spreadsheet which will work out a certain value for myself.  I am trying to figure out how I can do the following: If (such a cell)= the letter A and …

Creating an excel formulae with multiple options

I am trying to creeate a spreadsheet which will work out a certain value for myself.  I am trying to figure out how I can do the following: If (such a cell)= the letter A and …

What is the formula?

I need an excel formula to let me know, the # of cells where column B is blank but only if column A has content   By:

Combining functions

Hi, Im trying to comfine a COUNTIF and IF function into a single cell. Indivudually, the functions work, but I just needthem to work together Im scoring suppliers on 10 parameters …

Excel IF and AND functions trouble

Hello, Well I’m stuck. I’m trying to write a formula using the IF and AND functions that ought to be simple, but just can’t make it work. First I have a formula …

Excel formula question

I have two tabs, lets call them White and Black. In White I will record data, I.E cell A1 is a name, Chris.  cell B1 is a number, 200.  cell A2 is Jen.  cell B2 is …

double filtration with the last nearest date

I need to filter from two columns (name and date) select the value from a third column. Name can be matched exactly, but the date filtering is more tricky – it is the last …

How to create a 3D Graph from the following data

I have the following data in a .csv file that I import into Excel, once that is done I need to be able to create a 3D Bar Graph of that data. Date, Time, Quanity 2/13/2018,  …

update in one sheet an its automatically updates in the master sheet

i have two sheets one is sample another one is RTF, when i update value in RTF sheet its has to automatically update in sample file, the only thing is , there is already value in …

look up text formula

hello, I am having trouble writing out a lookup formula where if a certain text is located in a cell, then i want to look up another value in another column that contains a …

Count how many times Date appear within a range of Dates (not cells)

Hello, I’ve been trying to search for solution for hours now, and yet still can’t find it. So I really hope someone could help me. So here is what I need: I have Begin …

Excel expert

I have a 2 rows in excel table.- 1st row is for Month and 2nd row is for score. The table is dynamic that a new month is added after every month. I need a formula which counts the …