LinkBack URL
About LinkBacks
nickmangan 
Nick
Try this.
Formula:
=IFERROR(INDEX(List,SMALL(IF(NOT(ISNUMBER(FIND($B$2,List)))*NOT(COUNTIF(C1:$C$1,List)),ROW(List)-MIN(ROW(List))+1,""),1)),"")
Nick
Try this.
Formula:
=IFERROR(INDEX(List,SMALL(IF(NOT(ISNUMBER(FIND($B$2,List)))*NOT(COUNTIF(C1:$C$1,List)),ROW(List)-MIN(ROW(List))+1,""),1)),"")
If posting code please use code tags, see here.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks