Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula HELP!!
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
2 Nesting questions | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) |