grouping

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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...
 
You must log in or register to reply here.

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

Pls help with Excel Function 1
Access Compare records in same access table 0
hide duplicate data in a query 1
Display a 1 for the first of duplicates 4
How to Delete duplicate row access 2003 0
using duplicate function 13
Eliminate Duplicate Entries in Order to Create Labels Using Mail M 3
Removing duplicate records based off of date 3

Back
Top