![]() |
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. |
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