| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Seems simple, but...Please Help!!!
I'm looking for a function that will return the value of the first non-blank
cell in a range. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Seems simple, but...Please Help!!!
Try...
=INDEX(A2:A100,MATCH(TRUE,A2:A100<"",0)) ....confirmed with CONTROL+SHIFT+ENTER. Hope this helps! On Nov 1, 3:11 pm, Bullseye wrote: I'm looking for a function that will return the value of the first non-blank cell in a range. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Seems simple, but...Please Help!!!
Try this entered normally if TEXT
=INDEX(A2:A100,MATCH("*",A2:A100,0),0) -- Don Guillett Microsoft MVP Excel SalesAid Software "Bullseye" wrote in message ... I'm looking for a function that will return the value of the first non-blank cell in a range. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Seems simple, but...Please Help!!!
"Don Guillett" wrote...
Try this entered normally if TEXT =INDEX(A2:A100,MATCH("*",A2:A100,0),0) .... But if not text or not necessarily text, the following array formula would find it. =INDEX(A2:A100,MATCH(FALSE,ISBLANK(A2:A100),0)) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Simple problem, simple formula, no FUNCTION ! | Excel Worksheet Functions | |||
| Simple lookup - or maybe not so simple - help! | Excel Worksheet Functions | |||
| This has to be simple but...... | Excel Discussion (Misc queries) | |||
| Simple Simple Excel usage question | Excel Discussion (Misc queries) | |||
| Make it more simple or intuitive to do simple things | Charts and Charting in Excel | |||
Linear Mode
