LinkBack URL
About LinkBacks
If the columns are A and B enter this formula in column C and copy down the length of your data. Then, sort all the zeros to the top
Formula:
=IF(COUNTIF(B:B,A1)>0,1,0)
If the columns are A and B enter this formula in column C and copy down the length of your data. Then, sort all the zeros to the top
Formula:=IF(COUNTIF(B:B,A1)>0,1,0)
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks