First

Prev 
Next

Last
Pages: 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168
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 