LinkBack URL
About LinkBacks
In C2 with CTRL+SHIFT+ENTER rather than just ENTER
=INDEX(A:A,SMALL(IF(ISNUMBER(SEARCH(B$2,A$2:A$10)),ROW(A$2:A$10)),ROWS(C$2:C2)))
Then copy down...
In C2 with CTRL+SHIFT+ENTER rather than just ENTER
=INDEX(A:A,SMALL(IF(ISNUMBER(SEARCH(B$2,A$2:A$10)),ROW(A$2:A$10)),ROWS(C$2:C2)))
Then copy down...
Regards,
Haseeb Avarakkan
__________________________________
"Feedback is the breakfast of champions"
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks