Filter for frist record in a sorted list


G

Guest

I am trying to use a computed/calculated filter for a list of records sorted
by the first column. The first column has SSNumbers with multiple duplicates.
I want to filter for just the first SSNs of those duplicates - so a unique
list of SSN and what comes with that record.

This is what I came up with:
1. =$A2<>$A1 or =$A2<>$A3 (but this leaves either the first or the last
unique entry out).
2. =COUNTIF(SA$2:A2,A2)=1 (but then I get all the first duplicates together,
and no other records).

What should I have done instead?

Thanks so much for your solution.

Gerry
 
Ad

Advertisements

G

Guest

for your second equation, you should have two results 1s and 0s
the 1s shoul dbe bothe the first duplicate and the unique records
are yoiu using autofilter to then select what you want or what are you doing
after you have applied the euation.

you could also use advanced filter to select a unique lis of serial numbers
and then use Vlookup t select the first instancwe of match.
 
G

Guest

I use an advanced filter with the formula in the filter. So the formula does
not give me 0's and 1's by only TRUE or FALSE for the 1st record. Then I
apply the filter and do not get what I expect.
 
Ad

Advertisements

G

Guest

rather than using these equations with advanced filter,
I assume your data is sorted
I would use a helper column and change your equaition
to
in row 1 1
in row 2 =if(A2=A1,"",1)
copy row two down
use auto filter on the helper column and select the 1s
if not sorted
in the helper column row 1
=countif(A$1:A1,A1)
autofilter select 1s
 

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

Top