| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
the first in a sequence
Does someone knows how to find the first value after a number of empty cells?
|
|
#2
|
|||
|
|||
|
Try...
=INDEX(A1:A100,MATCH(TRUE,A1:A100<"",0)) ....confirmed with CONTROL+SHIFT+ENTER, not just ENTER. Hope this helps! In article , Willem wrote: Does someone knows how to find the first value after a number of empty cells? |
|
#3
|
|||
|
|||
|
Just an alternative:
=INDEX(A1:A100,MATCH("*?*",A1:A100&"",0)) Array-entered (ctrl+shift+enter). HTH Jason Atlanta, GA "Willem" wrote: Does someone knows how to find the first value after a number of empty cells? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I get the columns in Excel to go back to letter sequence | Excel Discussion (Misc queries) | |||
| How do I get the columns in Excel to go back to letter sequence | Excel Discussion (Misc queries) | |||
| How do I autofill an alphabetic sequence? (AAA, AAB, etc.) | Excel Discussion (Misc queries) | |||
| Controlling Sequence | Excel Discussion (Misc queries) | |||
| Formula for copying a sequence for every 8th cell | Excel Worksheet Functions | |||
Linear Mode
