• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 64
  • Last Modified:

advanced filter not working

I have a spreadsheet of data with numerous columns. I want to filter one column based on unique records only. I selected the advanced filter but its not filtering the data to one row per value there are numerous rows of data per unique value. Why would this be?
0
pma111
Asked:
pma111
  • 2
1 Solution
 
Phillip BurtonDirector, Practice Manager and Computing ConsultantCommented:
It should do - I've just tested it.

Can you post your spreadsheet and say what you are doing.
0
 
pma111Author Commented:
It did in the end, lol! Think the pure volume of data was causing some issues, took around 5 minutes to properly filter!
0
 
Phillip BurtonDirector, Practice Manager and Computing ConsultantCommented:
A quicker way, maybe, is to do a simple PivotTable with one field and no values.
0

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now