I don't use Vlookup much and it's not working for me. I know it's user error so can you tell me what I did wrong? I have two worksheets in my file. In the...

I don't know if I can do this in Excel, but thought it worth asking. I have a list of 80 clients. I need to know the cost for them, which is a complicated,...

I have this formula in N37 =SUM(G37:M37)/5 If the above result is 0, I want to count the number of times a specific code(PQ) is in a specific range on...

I'm looking for a formula that will calculate the following information: If 15% of the sum of a range of cells is less than $40.00 then the fee is $40.00. If...

Hi, how would I say: if cell e1 is a positive number, then return "win". If cell e1 is a negative number then return "looser". Thank you

I can not copy a cell from one workbook to a new one. when I right click the cell on the first workbook and then open a new workbook, the paste is not...

I am having a problem copying between workbooks. I usually just right click on copy and then go to the new workbook and right click paste. However, the...

Apologies if this seems a simple question, but I am at a bit of a loss on how to do it. I have two lists of people with a many to many relationship Group...

I am hoping some genius out there can help me with a formula. I want to do this…. First cell has total sales of 10,000, Second sell has fees of 100. I...

I have several sheets and I am trying to pull data from the master to the others, I have been trying to use the Lookup and IF function. But I cant get the...

Excel 2003 I receive information regarding patients in a hospital setting, the patient being identified by Medical Record Number. I need to know the number...

This is a small snapshot of what i have in 2 sheets:- Department/Category/Place-----------(3 similar columns for both...

How do I copy the contents of cell B2 into cell D2 only if D2 is empty

I am hoping some genius out there can help me with a formula. I want to do this…. First cell has total sales of 10,000, Second sell has fees of 100. I...

How do I copy the contents of cell B2 into cell D2 if D2 is empty

I have recently converted to Excel 2007 and upon opening a .xls file in compatibility mode, I find that no formulas work in the entire workbook, and all of...

This may be simple for everyone else except for me. I have a spreadsheet in which each column I can fill in one of three options (N/A, Yes, No). This is done...

Hi to all Elite Group members some time queries and their solution posted here are not in good format , its little bit confusing I want to request all of you...

You are probably tired of this type of question, but here goes. Is there any way to quickly go through a spreadsheet with the F2 Enter (to refresh a cell) ...

I have a spreadsheet that looks like this: Name | item 1 | item 2 | item 3 (etc.) I need to format it into: Name | item 1 Name | item 2 Name | item 3