Help with Pulling Sample Data

G

Guest

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

Herbert Seidenberg

This uses Advanced Filter.
Give each column a unique label, like this:

BinA BinB BinC
3945122 Jim Evans Group A
3815201 Ian Duffy Group B1
3815201 Lester Amp Group B1
3815201 Jay McMurray Group B1
.......

3945122 would be at location A2.
Enter these 3 cells somewhere, maybe at AA3:AA5

Test
=COUNTIF($A$2:A2,A2)=1
=COUNTIF($A$2:A2,A2)=2

Under Test, it will say either TRUE or FALSE. That's OK.

Filter > Advanced Filter > Copy to another location (maybe AH1)
List Range > $A$1:$C$14
Criteria Range > $AA$3:$AA$5
Copy To > $AH$1:$AJ$1
 

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

Similar Threads

Concatenating fields 0

Top