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
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)
Bookmarks