Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Advanced Filters

Status
Not open for further replies.
daver676

daver676

Programmer
May 21, 2003
4
SG
Hello,

When trying to use an advanced filter, the filter does not display all the records that match the criteria, it only displays the first one it finds. What could the problem be?
Any advice would be helpful....
Thanks
Dave
 
Sort by date Sort by votes
I think your problem is that the 'Advanced Filters' option has the "unique records only" checkbox ticked (bottom left of the 'Advanced Filter' window). This option would only show one occurence of each criteria. Un-tick the checkbox for all criteria to show.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

wmbb
  • Locked
  • Question
How to reset the defined filters of the msoFileDialogFilePicker
Replies
2
Views
174
wmbb
wmbb
EliseFreedman
  • Locked
  • Question
Conditional Formatting and advanced Filtering
Replies
6
Views
101
SkipVought
S
chipawawa
  • Locked
  • Question
Excel Advanced Filter and Hypelinks
Replies
5
Views
72
SkipVought
S
Cpreston
  • Locked
  • Question
Macro to count advanced searches in outlook 2010
Replies
0
Views
42
Cpreston
Cpreston
Kekins1
  • Locked
  • Question
two filters that work fine indepentently but override eachothers results
Replies
3
Views
64
SkipVought
S

Part and Inventory Search

Sponsor

Back
Top