goodpasture Wrote:
I have 2 columns (A and B) and each has 3 or 4 digit numbers all mixed
up. Basically I need to be able to match them up (if there is a match)
and I am going to delete them if they are both in A and B but I need to
know which ones are ONLY in A and also which ones are ONLY in B which is
what should be left...right???

Thanks,

Jonathan

Hi Jonathan

Try this in column C, =IF(COUNTIF($A$1:$A$10,B1)=0,"No Match","Match"),
change the range A1:A10 to suit your data, it will identify all matches
so if column A contains 1234 twice and 1234 is also in column B both
will show as a match


--
Paul Sheppard


------------------------------------------------------------------------
Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783
View this thread: http://www.excelforum.com/showthread...hreadid=399044