Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Duplicate Data
I have a spreadsheet with 19 columns. With the exception of 2 columns, the
rest will be duplicates. For instance, the address, city, state, grade, category will all be the same and repeated but the item type and picklist may be different. I need to be able to pull out the duplicates and not count the addresses or grades twice. I have tried pivottables but can't seem to get what I need. I have also tried Access but I am really not familiar with that program...what I have tried does not appear to be working. I have researched duplicate records, but it talks about every cell in every row being an exact duplicate. That is not what I have...I only have certain columns being exact duplicates. Does anyone know what I can do? Thanks, Heather |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Duplicate of data | Excel Discussion (Misc queries) | |||
identify duplicate data upon entry of that data | Excel Discussion (Misc queries) | |||
Import data and keep duplicate rows of data | Excel Discussion (Misc queries) | |||
comparing lists of data to remove duplicate data | Excel Discussion (Misc queries) | |||
how can i locate duplicate data in an excel data table? | Excel Worksheet Functions |