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

Formula to Extract Text from Cell

I’m trying to figure out the formula to extract the below data and place it in another cell. They will come in through emails and the content (below) will be pasted into a …

Excel work Lottery prediction

To whom this may concern,   I have a question in regards to my project which involves working out a secret formula in the determining the odds section to provide the winning …

Formula Help

Hi   I have a spreadsheet with factory name, review date and overall evluation. Some factories may have multiple entires and reviews. I would like the overall evluation to …

looking age of last non-matching value

I have data that looks like this (three columns: Date, IGN and AP):   Date IGN AP 8/8/2019 Emxmari0 3560 8/11/2019 Emxmari0 3580 8/12/2019 Emxmari0 3580 8/16/2019 Emxmari0 …

solution

Suppose =IFERROR(5000/2,1000)+100 is entered into a cell. What is the resulting output of this formula? By:

Divide numbers

Hi, Hope you’re fine and healthy. I have a time sheet for my employees and the working days of each employees calculates based on projects that employee receive salary. for …

Automatic match

Hi, Would very much appreciate your assistance tackling the following conundrum:  I have two separate sheets.  In sheet 1: I have a column A for numbers and column B for …

Help with formula, please!

Hi!   I’m hoping someone can help me with this formula. I am looking for a formula to use that take the words that are in separate cells in a column, and …

Change into decimal

I unable to convert the amount i in Ms Excel to lakh in decimal. e.g. 234567  convert to 2.34 By:

Tracking value changes to a number

I am trying to figure out what formula I would use to track value changes to my Blank Permits. For example, I have an Export Permit # 05064578 with several items in it with a …

INDEX / INDIRECT

I am using the INDIRECT function to get data from a file and would like to use the INDEX,MATCH function instead. This would mean the i can access the data witout opening the file. …

mulit formulas within a cell

I am doing time tracking for my job… We run 12 jobs with 2 emplyess I want to say: Queens St had 8 hours of labor  with in that cell I want to track that  Emplyee …

mulit formulas within a cell

I am doing time tracking for my job… We run 12 jobs with 2 emplyess I want to say: Queens St had 8 hours of labor  with in that cell I want to track that  Emplyee …

Help !

I am having trouble with a project I am doing with Excel. For my statistics class I have to show the maximum temperature of the 50 states in a 30 day period. I put my data in, use …

Multiple LOOKUP criteria

Is it possible to have multiple criteria in a LOOKUP formula?  By: hands in

excel

I have some product list that are sold every month. I need to find the rate of sale for them now the rate of sale for them now the rate of sale should be sum of the column by …

Excel help

Hello, I need to formulate the following row A 0 0 0 1 2 3 4 5 Row B Period end              Period end Period end Row c Date Date Date Date …

Data in consecutive cells

I want to room students for specific exams. I would like to input a formula or something to allow 24 cells to be populated with the same room number. Is this possible? By: Cagney …

Cell References in Excel Macro

Hi, I want to write a Macro in excel then it can find whatever in C2 and replace it with C1 in the whole worksheet. Please could you advice what to write it the Ctrl-H (find and …

dalmia

Using Sumifs, pls calculate total Item received by each warehouse and the amount of item received by each ware house                   …

Round up the cell contains symbol with number

Round up the cell contains symbol with number   Eg ↓9.849639   output should be ↓9.85 …