finding & filtering out duplicate cells

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

Guest

I have 3 columns & about 40 rows of accounts (text). I would like to be able
to find all the duplicate accounts and have them filtered out to a blank
column. Data sort does not work because of the volume of accounts & number
of columns. I have tried advanced filter but it only copies the entire cells
-- does not just give me the duplicate records. I really appreciate your
help with this!
 
Hi Jackie,
I have tried advanced filter but it only copies the entire cells
-- does not just give me the duplicate records
Click to expand...

Checking the 'Unique records only' option on the Advanced Filter dialog
should do exactly that. You can optionally filter the unique records in
situ, or copy them elsewhere.

In what way does this not work for you?
 
even using unique records only just copies all the records to the new column
... does not filter out only the duplicates ....
 

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

Duplicates Deletion ? 2
Highlighting duplicate cells in a column 2
Filter out duplicates 1
Sorting/Filtering Info 2
filtering out rows with duplicate information 1
Bug in Advanced filter 1
Finding Unique records 3
Duplicate data 2

Back
Top