Functions

Match value in one column and return value in same row in next col
Hi, I have a a set of values in A1 through A100. I need to look up each value and find a match in another set of values located in C1 through C200. If a match is found then I need the formula located in column B to return the value in the same row but the next column over (D). Example: A B ... 6 Mar 2010 16:18

Retain pivot table formatting after refreshing data
I used Sheet1 as the data source to create a pivot table in a new worksheet which I named PT Sheet. Using Excel 2003, I took the following steps to do it - Created the pivot table with the pivot table wizard. - In Step 2 of the wizard I expanded the range of the rows well beyond what I needed to piv... 6 Mar 2010 12:59

Excel 2007
The idea is if not enough milk is brought then the affected meals will need to be subtracted from the breakfasts then lunch. If value formulas. Breakfast 0 0 0 Lunches 0 0 0 PM Snacks 0 0 #DIV/0! Suppers 0 0 0 Highest Quantity of Meals Served #DIV/0! Onces Gal... 6 Mar 2010 10:46

updating data in worksheet..!
hi all! i have to update a workbook on daily basis. today I am having values from A1:A3 as 50,60,70 & B1:B3 10,20,30. while updating tomorrow i will change only the values in B1:B3 to 20, 30 & 40 and doing so the values in A1:A3 should change as A1+B1, A2+B2 & C1+C2 ie) 70,90,110. the next day the values in B1:... 7 Mar 2010 10:43

multiplying fractions
Hi, i am trying to do something on excel, but cannot for the life of me figure what formula i should write.. This may help if i explain first - I have a column with a number in it (the answer)... I have a column with the fraction 1/20 in it.. Then i want a column that will multiply these 2 columns together ... 6 Mar 2010 11:52

Negative result gives #### is there a way to show the actual - num
Hi The result of a formula gives me ##### for a negative number. Is there a way to get the actual negative number (i.e. for example -9 instead of ###)? Alternatively maybe show a 0 (zero)? Sending a report to my boss with #### doesn't look so great. Maybe a minimum number formula? Thanks ... 7 Mar 2010 22:53

protection indicator
Hi I write two question a bout this but no answer pleas, if possible I want a function that if worksheet protected write a text in a cell like "protected" if not protected, write "unprotected". kind regards nader ... 7 Mar 2010 08:31

Conditional Formatting Query
Hi I'm facing a problem from last month but I'm not able to put conditional formatting with Icons. If somebody can help as its really urgent for me !!!!! I have values for two months - Current and Previous. If current month's value is closer to zero than previous month's value then i want to show a gree... 6 Mar 2010 05:20

Finding Average of last 5 entries
I'm trying to figure out a way to make an excel spreadsheet that will help me out with my players golf scores. I'd like a spreadsheet that I can enter scores in for each player daily, but will only give me an average for the lowest 4 out of their most recent 5 scores. I'd like to have their older scores still... 8 Mar 2010 19:50

Entering Values and Updating Next Empty Cell in a Range
Please help, I hope there is a macro. Every time I enter a value in cell j29, I would like it to post to the next empty cell in range b139:b150. For example, if I enter 24 and it populates b139, the next value I enter in j29 should post in b140 Thanks - Tom ... 13 Mar 2010 23:06