grouping

E

eddie

I'm trying to show only one instance of duplicate records with no luck. Any
suggestions?
 
G

GerryK

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.
 
E

eddie

Thanks for the info Gerry. Worked perfectly.



GerryK said:
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?
.
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Report Group Footer DLookUp 0
How to open multiple instances of Word 365? 5
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Notes not showing up in Powerpoint Presenter Mode 0
Word doc keeps changing to ALL CAPS 0
I have lost 6 months work, how can i get my file back 1
Duplicate entry in a column/row 14
Mail Merge skipping records/sending one at a time 0

Top