filtering out rows with duplicate information

G

Guest

I have a spreadsheet with about 2800 rows of information. 3 columns: ID#,
Name, & Fax number. The fax column contains several rows of duplicate fax
numbers. I am trying to remove or filter out the duplicate fax numbers using
the Advanced Filter tool. I'm following the instructions step by step but
it's not working and I'm not sure what I am doing wrong. Can someone help?
 
G

Guest

I just figured out what I did wrong: I had opened a .csv in Excel, thinking
that it was in .xls format. As soon as I saved it as an Excel spreadsheet, it
worked.
 

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

finding & filtering out duplicate cells 4
remove duplicate rows but keeping all columns 3
Identify duplicate rows 1
Is there an easy way to filter duplicate rows of data in excel? 1
Clearing information in certain columns 1
Identifying duplicate rows 2
questions on advanced filter 4
How do I delete both duplicate rows from a spreadsheet? 3

Top