Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Duplicate and unique items in 2 lists
Hi all,
I have cpearson's examples but I can't figure out what to do if the entries are in 2 separate worksheets, alphanumeric, and in 2 cells, eg one cell contains item (alpha) and another price (numeric) . I want to compare if an updated list sent to me has any duplicates and highlight what the difference is. Thanks again |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Duplicate and unique items in 2 lists
"Vince" wrote:
I have cpearson's examples but I can't figure out what to do if the entries are in 2 separate worksheets, alphanumeric, and in 2 cells, eg one cell contains item (alpha) and another price (numeric) . I want to compare if an updated list sent to me has any duplicates and highlight what the difference is. Try this previous response to a similar query: http://tinyurl.com/ffyum The link to the sample construct in the response is still valid but my archives host: savefile.com is still down at the moment .. Here's an alternate link to the same sample (full details inside): http://cjoint.com/?ixilcpUvl7 Extract non dupes betw 2 shts (2 col data).xls (Link above is good for 14 days) -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Setting up a validation of data listbox to provide the unique items within a range | Excel Worksheet Functions | |||
Deleting All Rows for Duplicate Entries Except Those With Most Items In Row | Excel Discussion (Misc queries) | |||
Unique and duplicate data between 2 Excel worksheets | Excel Worksheet Functions | |||
count duplicate (or, inversely, unique) entries, but based on a condition | Excel Worksheet Functions | |||
How to delete duplicate records when I merge two lists (deleting . | Excel Worksheet Functions |