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
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