You could put a heading in D1 and this formula in D2:
=IF(ISNUMBER(MATCH(B2,C:C,0)),"Y","N")
and copy down, and then you could apply a filter to column D to select Y.
Hope this helps.
Pete
You could put a heading in D1 and this formula in D2:
=IF(ISNUMBER(MATCH(B2,C:C,0)),"Y","N")
and copy down, and then you could apply a filter to column D to select Y.
Hope this helps.
Pete
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks