| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Finding the bottom non-blank cell in a range
Hi!
Try this entered as an array using the key combination of CTRL,SHIFT,ENTER: =INDEX(A1:A100,MATCH(TRUE,A1:A100<"",0)) Biff "igbert" wrote in message ... Hi, Ias there a similar formula to find the first non blank cell in a range? Igbert "starguy" wrote: try this? =LOOKUP(2,1/(range<""),range) -- starguy ------------------------------------------------------------------------ starguy's Profile: http://www.excelforum.com/member.php...o&userid=32434 View this thread: http://www.excelforum.com/showthread...hreadid=534500 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Blank (empty) cell always equal to 0?? | Excel Discussion (Misc queries) | |||
| need to Copy or Move to active cell from specified range | Excel Discussion (Misc queries) | |||
| Match function...random search? | Excel Worksheet Functions | |||
| blank cell turns to 0 | New Users to Excel | |||
| if the value of a cell in a range is not blank, then return the v. | Excel Worksheet Functions | |||
Threaded Mode
