Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Comparing 2 lists
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Comparing 2 lists
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Comparing two lists | Excel Worksheet Functions | |||
Comparing lists | Excel Worksheet Functions | |||
Comparing Lists to Partial Lists | Excel Programming | |||
Comparing lists | Excel Programming | |||
Comparing 2 Lists | Excel Programming |