Problem filtering for unique records

G

Guest

I can't seem to get the filter for unique records to work. I have a
spreadsheet with about 20 columns and about 3000 rows. If I create a
separate worksheet containing data only from the columns I want to filter for
the unique records, and then choose Advanced Filter, and the list range and
criteria range are the same, and click "Unique Records Only", it works. But
if I try to filter the complete worksheet with all 20 columns, and set up the
filtered columns as the criteria and all the columns as the list range, it
just gives me back the same set of rows, including duplicates.

What am I doing wrong?
 
D

Douglas J. Steele

This newsgroup is for questions about Access, the database product that's
part of Office Professional.

Since your question appears to be about Excel, you'd be best off reposting
to a newsgroup related to Excel.
 
D

dbahooker

more appropriately

you'd be best off LEARNING A DATABASE INSTEAD OF USING EXCEL FOR
REPORTING
 

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

Filtering for Unique Records with multiple-column criteria 5
Filtering For Unique Records 1
unique records by advanced filter 10
COMBINING UNIQUE VALUES FROM 4 COLUMNS INTO 1 5
VBA: How can I use a string variable as autofilter criteria? 4
Access Dcount (multiple criteria) 3
Filtering for Unique Records in an Access Database 5
Filer for unique records and return all column data for unique rec 1

Top