Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Filter for frist record in a sorted list
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Filter record on color scheme | Excel Worksheet Functions | |||
Sorted list | Excel Discussion (Misc queries) | |||
Record count in filter mode | Excel Discussion (Misc queries) | |||
advance filter excluding record | Excel Discussion (Misc queries) | |||
Why does my advance filter only show one record? | Excel Discussion (Misc queries) |