Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Comparing against first non-blank cell
Okay, here's the problem:
I have two columns: A and B. A is a listing of stock prices, in random order. B is a column of Peaks or Price Highs, based on column A. SO: A1=B1. B2: IF(A2B1, A2, ""). The return here is " " (so I have B1 with a value, then B2 with a blank). Now, for B3: I want to say IF B2 is a blank, then go to B1 and check that there is a value there; if so, IF A3this first non-blank cell, THEN B3=A3. And I want it to slide down the column as I go. Meaning that if I have a value at B1, B2, B3, then blanks to B10, then the NEXT comparison will be against B10 (since that's the last non-blank cell in the column, SO FAR). So it's a moving formula, as I work my way down the spreadsheet as opposed to being at the end of a column and looking upward to a single cell with the first nonblank cell I see. Thank you for your help. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Comparing against first non-blank cell
A trying to perform a similar function myself - have you had any suggestions on this one yet? -- Montrose77 ------------------------------------------------------------------------ Montrose77's Profile: http://www.excelforum.com/member.php...o&userid=18191 View this thread: http://www.excelforum.com/showthread...hreadid=535689 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Urgent date/scheduling calc needed | Excel Worksheet Functions | |||
Blank (empty) cell always equal to 0?? | Excel Discussion (Misc queries) | |||
Return of blank cell if lookup fails | Excel Worksheet Functions | |||
Setting Purely BLANK Cell | Excel Worksheet Functions | |||
Replace null string with blank cell | Excel Discussion (Misc queries) |