View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Slim Slender[_3_] Slim Slender[_3_] is offline
external usenet poster
 
Posts: 38
Default Select two items from many

There are about 100 records in a table. Column A has names in it, many
different names and each name occurring from 1 to any number of times.
I want to select a group of records consisting of the first two
occurances of each name. In the case where a name occurs only once,
one record. The records can be sorted by name.