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.
 
Back
Top