So, use this one in B2. Also Array.
=INDEX(day1_, SMALL(IF(ISBLANK(day1_),"";ROW(day1_)-MIN(ROW(day1_))+1), ROW(A1)))
BUT: Be carefull. Your A4 cell ISNOT blank. To try if this is TRUE, put this in another empty cell =ISBLANK(A4)
So, use this one in B2. Also Array.
=INDEX(day1_, SMALL(IF(ISBLANK(day1_),"";ROW(day1_)-MIN(ROW(day1_))+1), ROW(A1)))
BUT: Be carefull. Your A4 cell ISNOT blank. To try if this is TRUE, put this in another empty cell =ISBLANK(A4)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks