Hi M3Cobb
Srr Chip Pearson at:
http://www.cpearson.com/excel/duplic...tingDuplicates
If I have 2 lists of numbers in columns A and B, is there anyway of
extracting the numbers that occur in both lists?
On the above page, see the section entitled:
Extracting Values Common To Two Lists
or maybe even the numbers that only occur in the list in Column B.
On the above page, see the section entitled:
Extracting Values On One List And Not Another
---
Regards,
Norman
"M3Cobb" wrote in
message ...
If I have 2 lists of numbers in columns A and B, is there anyway of
extracting the numbers that occur in both lists?
or maybe even the numbers that only occur in the list in Column B.
cheers
--
M3Cobb
------------------------------------------------------------------------
M3Cobb's Profile:
http://www.excelforum.com/member.php...o&userid=24986
View this thread: http://www.excelforum.com/showthread...hreadid=389845