Array formula:
=IFERROR(INDEX(Sheet1!$A$1:$A$30,SMALL(IF(NOT(ISNA(Sheet1!$A$1:$A$30)),ROW(Sheet1!$A$1:$A$30)-ROW(Sheet1!$A$1)+1),ROWS($A$2:A2))),"")
Na.xlsx
And Custom Format
0;-0;;@
Array formula:
=IFERROR(INDEX(Sheet1!$A$1:$A$30,SMALL(IF(NOT(ISNA(Sheet1!$A$1:$A$30)),ROW(Sheet1!$A$1:$A$30)-ROW(Sheet1!$A$1)+1),ROWS($A$2:A2))),"")
Na.xlsx
And Custom Format
0;-0;;@
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks