I've been scratching around and i'm probably asking this the wrong way around. I'm looking for a formula that I can use that will look at column A and column B and if duplicates (between A and B) are found both the cells are emptied leaving just the unique cells in column A and B. Or perhaps take the unique cells and place in column C and D respectively.
I'd start with a VLOOKUP in column C, and if the VLOOKUP of the value in column B is found in column A, you know it's duplicate. Then in columns E & F, you can say if the VLOOKUP value was an error (or use IFERROR with your VLOOKUP to make it whatever you want), then equal A or B respectively, if not, equal blank.
<--- If you like the answer, press *.
Put this in C1:
=IF(COUNTIF($B$1:$B$100,A1)=0,A1,"")
And this in D1:
=IF(COUNTIF($A$1:$A$100,B1)=0,B1,"")
and drag down
When I say semicolon, u say comma!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks