Identifying next number in a range and referencing it
Thanks a lot!
"Teethless mama" wrote:
=IF(ISERR(SMALL(IF(data<"",ROW(INDIRECT("1:"&ROWS (data)))),ROWS($1:1))),"",INDEX(data,SMALL(IF(data <"",ROW(INDIRECT("1:"&ROWS(data)))),ROWS($1:1)) ))
ctrl+shift+enter, not just enter
copy down as far as needed
"Verlaesslichkeit" wrote:
My column looks like this
4101801
4101901
41011001
41011101
there are spaces here
41011205
41011301
Now, I would like to have this list without spaces (without using a filter)
purely by using formulas at another location, so that the final result looks
like this:
4101801
4101901
41011001
41011101
41011205
41011301
I have been trying for hours but dont get tanywhere, Im probably thinking
way to complicated.
Many thanks!
|