| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
grouping
I'm trying to show only one instance of duplicate records with no luck. Any
suggestions? |
|
#2
|
|||
|
|||
|
Will this help?
Select the range, use Data/Filter/Advanced filter check Unique Records Only and "Copy to another location" Put in an address to hold the result, eg[F1] then click OK. When you're done, you will have the unique records in the new place. You can delete the original range if you need to. -----Original Message----- I'm trying to show only one instance of duplicate records with no luck. Any suggestions? . |
|
#3
|
|||
|
|||
|
Thanks for the info Gerry. Worked perfectly.
"GerryK" wrote: Will this help? Select the range, use Data/Filter/Advanced filter check Unique Records Only and "Copy to another location" Put in an address to hold the result, eg[F1] then click OK. When you're done, you will have the unique records in the new place. You can delete the original range if you need to. -----Original Message----- I'm trying to show only one instance of duplicate records with no luck. Any suggestions? . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot table grouping | Excel Discussion (Misc queries) | |||
| Can I use the grouping and lock and protect cells | Excel Discussion (Misc queries) | |||
| how to format numbers, digit grouping ,as per regional settings | Excel Discussion (Misc queries) | |||
| Pivot table-date grouping | Excel Discussion (Misc queries) | |||
| How to enable grouping in a protected sheet | Excel Worksheet Functions | |||
Linear Mode
