Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
sorting 2 colums of numbers and incremening them down | Excel Discussion (Misc queries) | |||
Inputting data to one worksheet for it effect another | Excel Discussion (Misc queries) | |||
Pulling Data off Web - Need Function Help | Excel Worksheet Functions | |||
Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions |