View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
excelmad excelmad is offline
external usenet poster
 
Posts: 9
Default Help with Pulling Sample Data

I have a very large file that contains data as follows:
Column A Column B Column C
3945122 Jim Evans Group A
3815201 Ian Duffy Group B1
3815201 Lester Amp Group B1
3815201 Jay McMurray Group B1
3815201 Owen Wright Group B1
3815201 Karen Wrigley Group B1
3814207 Adel Williams Arizona
3814207 Isabella Luis Arizona
3814207 Connor Lemon Dennis
3814207 Maria Left Form 1
3914512 Adam Archer FrontB
3914512 Monique Archer Item 5
3954763 Susie Smith JessV

What I was looking to get was a sampling of column A (two records). For
example I only need:
3945122 Jim Evans Group A
3815201 Ian Duffy Group B1
3815201 Lester Amp Group B1
3814207 Adel Williams Arizona
3814207 Isabella Luis Arizona
3914512 Adam Archer FrontB
3914512 Monique Archer Item 5
3954763 Susie Smith JessV

Please note that I have data to column N, row 18284 and there is some data
in column A that is only one record (ex. 3945122). In that case I would only
need the one record but for all others I would be looking for two records.
Please let me know if there is a solution.