Hi
Another way to trap the error...
=IF(ROWS(A$26:A26)<=COUNTA(A$3:A$23);INDEX(A$3:A$2 3;SMALL(IF(LEN(A$3:A$23);ROW(A$3:A$23)-ROW(A$3)+1);ROWS(A$26:A26)));"")
again it's an array formula. confirmed with CTRL+SHIFT+ENTER
Hi
Another way to trap the error...
=IF(ROWS(A$26:A26)<=COUNTA(A$3:A$23);INDEX(A$3:A$2 3;SMALL(IF(LEN(A$3:A$23);ROW(A$3:A$23)-ROW(A$3)+1);ROWS(A$26:A26)));"")
again it's an array formula. confirmed with CTRL+SHIFT+ENTER
Cheers !
Excel Range to BBCode Table
Use Social Networking Tools If You Like the Answers !
Message to Cross Posters
@ Home - Office 2010/2013/2016 on Win 10 (64 bit); @ Work - Office 2016 on Win 10 (64 bit)
Posting Permissions
Reply With Quote
Bookmarks