grouping
I'm trying to show only one instance of duplicate records with no luck. Any
suggestions? |
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? . |
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? . |
All times are GMT +1. The time now is 10:59 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com