ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Help with Pulling Sample Data (https://www.excelbanter.com/excel-discussion-misc-queries/128639-help-pulling-sample-data.html)

excelmad

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.

Herbert Seidenberg

Help with Pulling Sample Data
 
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



All times are GMT +1. The time now is 02:14 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com