or can try
change range reference as per your needs![]()
=IFERROR(INDEX($B:$B,SMALL(INDEX(ISNA(MATCH($B$1:$B$1000,$A$1:$A$2000,0))*10^10+ROW($B$1:$B$1000),0),ROWS(C$1:C1))),"")
or can try
change range reference as per your needs![]()
=IFERROR(INDEX($B:$B,SMALL(INDEX(ISNA(MATCH($B$1:$B$1000,$A$1:$A$2000,0))*10^10+ROW($B$1:$B$1000),0),ROWS(C$1:C1))),"")
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks