I need to make a formula that if any item in column E is equal to any of the items in column A then the quantity in column F(beside the item in E) needs...

Hello I need to add conditional formatting to a cell (B1) based on a column of cells (F27 to F41). The cells contain a pick list of text "Ahead", "On Track"...

A variation of a multiple criteria lookup question, this time using the "max" function: Column A Column B Column C Apples ...

Hello, I have in my spreadsheet as follows: A B C 1 PO200 2 ...

Hi I am designing a pivot table to give a monthly report and i have clicked the box in table options to update to refresh on opening the spreadsheet, but this...

Hi, I'm trying to work out a way of getting Excel 2003 to answer y=2i+1 when i=1 initially with a final value of 10. y=(2x1+1)+(2x2+1)+...+(2x10+1) I could...

I am trying to find which items in Column B are missing from A (finding the reverse would be helpful to; any in column A not in column b) Column A has data...

what does Show Ink in Excel, Review Tab, comment, do? or what do I have to look under to find information.

I am getting an error with my formula and wondering if its just punctuation? =IF(ISNA(MATCH,(F14,'CAU - Maturing Loans'!$F:$F,0,)""(INDEX('CAU - Maturing...

I had few macro in my sheet. Now I have deleted all the macro's in my sheet But still I get the message box to Enable or Disable macro when I open my...

Using Excel 2007 I'm having a new problem not faced in Excel 2003. Sometimes when I enter a function and press enter the function formula shows but not the...

Hi - I have a financial data spreadsheet with hundreds of vlookups. As the spreadsheet grows over time, is there any way of knowing what the resource impact...

Hello, How do I create a hyperlink to a graph sheet within Excel? I know to create a link to different sheets but I can't link to graph? Can any one...

I have the following formula but it is not gving me the results I am looking for: =IF(TYPE(VLOOKUP(V2,'thread...

I can't get this formula to work, please...

Hello! How to convert all 3d references to normal references in a workbook? I want to move the ranges to which the 3d references refer, but the 3d references...

Hello I am trying to create a formula which can look up to find data on a raw and returns the value on the same column on another raw. Here is the outline of...

How can I generate a list of random dates from dates I specify

I figured out how to make a drop down menu. Now I want to add in more data when I choose a certain item from my drop down. My sheet is for a meal...