Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to compare and sort rows in Excel
I'm trying to figure out how to take one group of rows (A), compare
that to another group (B), and create a new list of rows from what ever is in group A but Not in group B. There my be things in B that are not in A, but I don't want those on the new list. The rows that are in both lists will be exact duplicates (with VIN numbers matching as well as all other columns). I've poked around in Excel and am not well versed in it enough to know how to do this. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to compare and sort rows in Excel
Look at advanced filter.
Data--Advanced filter, and select unique records only. See if that helps. Dave -- Brevity is the soul of wit. " wrote: I'm trying to figure out how to take one group of rows (A), compare that to another group (B), and create a new list of rows from what ever is in group A but Not in group B. There my be things in B that are not in A, but I don't want those on the new list. The rows that are in both lists will be exact duplicates (with VIN numbers matching as well as all other columns). I've poked around in Excel and am not well versed in it enough to know how to do this. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to compare and sort rows in Excel
Dave F wrote: Look at advanced filter. Data--Advanced filter, and select unique records only. See if that helps. I think that would pick up the ones in Group B that are not in A, and I don't want those. Dave -- Brevity is the soul of wit. " wrote: I'm trying to figure out how to take one group of rows (A), compare that to another group (B), and create a new list of rows from what ever is in group A but Not in group B. There my be things in B that are not in A, but I don't want those on the new list. The rows that are in both lists will be exact duplicates (with VIN numbers matching as well as all other columns). I've poked around in Excel and am not well versed in it enough to know how to do this. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to file compare Excel worksheets | New Users to Excel | |||
How do I sort or compare data from 2 different spreadsheet columns | New Users to Excel | |||
How to compare two column of data and sort them out according | New Users to Excel | |||
Formula to compare multiple rows values based on another column? | Excel Worksheet Functions | |||
How to sort/update large excel db | Excel Discussion (Misc queries) |