=INDEX('Pulled Data'!$A$1:'Pulled Data'!$A$50000,SMALL(IF(LEN('Pulled Data'!$A$1:'Pulled Data'!$A$50000),ROW($1:$50002)),ROW('Pulled Data'!A1)))
I have this formula and it was working fine. I have not made any changes but suddenly it started returning a N/A any ideas why
Maybe try with Ctrl+Shift+Enter
=INDEX('Pulled Data'!$A$1:$A$50000,SMALL(IF(LEN('Pulled Data'!$A$1:$A$50000),ROW($1:$50000)),ROW('Pulled Data'!A1)))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks