Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Look for the first non-blank cell above!
Hi all,
What would be the formula to locate the cell of the first non-blank cell above? I was playing with MATCH function but the first parameter doesn't take zero-length string ("")! Cheers, --- Tetsuya Oguma, Singapore |
#2
|
|||
|
|||
Assuming the formula ism in F24, use
=MAX((OFFSET(F24,-1,0,-23,1)<"")*ROW(OFFSET(F24,-ROW()+1,0,ROW()-1,1))) as an array formula, so commit with Ctrl-Shift-Enter -- HTH RP (remove nothere from the email address if mailing direct) "Tetsuya Oguma" wrote in message ... Hi all, What would be the formula to locate the cell of the first non-blank cell above? I was playing with MATCH function but the first parameter doesn't take zero-length string ("")! Cheers, --- Tetsuya Oguma, Singapore |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Setting Purely BLANK Cell | Excel Worksheet Functions | |||
Replace null string with blank cell | Excel Discussion (Misc queries) | |||
Look for change next blank cell in Range | Excel Worksheet Functions | |||
Go to first blank cell | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions |