Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Compare 2 lists and show reconciliing items
Is there any easy macro to look at a range of values (numbers) in a
column on one worksheet, look up a range of values in a column in another worksheet, and (a) paste into another worksheet the values that appear in the first but not the latter, and (b) that pastes in another worksheet the values that are common to both? Thanks for any suggestions. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
compare lists | Excel Worksheet Functions | |||
How do I compare two lists and choose the items that are in both? | Excel Worksheet Functions | |||
Formula to compare two lists and separate non-recurring items? | Excel Worksheet Functions | |||
Compare 2 columns, and create a list of items that are in both lists | Excel Worksheet Functions | |||
How do I compare 2 lists and show duplicates as a new list? | Excel Programming |