Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
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.
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,180
Default 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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
sorting 2 colums of numbers and incremening them down blk&wht Excel Discussion (Misc queries) 10 October 9th 06 10:12 PM
Inputting data to one worksheet for it effect another daedalus1 Excel Discussion (Misc queries) 1 June 25th 06 04:39 PM
Pulling Data off Web - Need Function Help patfergie44 Excel Worksheet Functions 9 June 22nd 06 03:27 AM
Excel Macro to Copy & Paste [email protected] Excel Worksheet Functions 0 December 1st 05 01:56 PM
Help PLEASE! Not sure what answer is: Match? Index? Other? baz Excel Worksheet Functions 7 September 3rd 05 03:47 PM


All times are GMT +1. The time now is 03:36 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"