Incorrect Advanced Filter Action

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

Guest

Hello There,

using the advanced filter option I ran into some difficulties.

When I asked it to place only Unique Records in a cell it did the following:

Source:

ARF Codes
ARF555
ARF555
ARF000
ARF777
ARF000
ARF555
ARF777
ARF777
ARF555
ARF000
ARF000
ARF000
ARF555
ARF777

Output:
ARF555
ARF555
ARF000
ARF777

As you can see there are still to of the same codes. Does anyone know what
could have went wrong and what can be done to prevent such a thing? Thanks!
 
Did you have a heading cell on the data when you ran the filter, or was
ARF555 in the top cell?

If you had a heading, perhaps one of the ARFF555 has a trailing space
character.
 
Correct! Thanks! ARF555 was functioning as a header rather than as data.
Fixed it, all works fine now.
 
You must log in or register to reply here.

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

Advanced filtering and sums 3
Advanced filter result showing blank columns 1
How to Unfilter a List that has been filtered via Advanced Filter >Unique Records only 1
Advanced Filter Unique Records Only - treats dependent cells inconsistently 2
Can Advanced Filter be automated? 7
Advanced FIlter behaviour? 4
advanced filternot working in macro 1
Data - Filter - Advanced - Unique records only 2

Back
Top