LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 131
Default Pick of random ID's

I need to pick number of random ID's as per COL N from Col A where Col B =
Col L

Eg: Pls See Table below..

I have 201 records in Col A (Numbers) in which 62 are HRE, 7-KRK, 17-PRT,
42-RPA, 73-RPX

Ineed to pick 6 random ID's (which may differ as per number in col N) from
COL A where Col B = HRE (Col L)

Similarly, it will be for other rows in col N where value is 0



Col A Col B Col C Col D.... Col L Col M Col N
521 HRE AHA 0 0
630 RPA FNT 0 0
595 HRE FRT 0 0
656 RPA HRE 62 6
693 RPA HTA 0 0
730 HRE KCK 0 0
767 RPX PRT 7 1
804 PRT NFC 0 0
841 HRE HPA 0 0
878 PRT HPR 0 0
915 PRT HPX 0 0
952 PRT PNT 0 0
989 RPX PRT 17 2
1026 RPX RPA 42 4
1063 PRT RPX 73 7
1100 HRE CHS 0 0
1137 PRT NST 0 0
1174 PRT 2NS 0 0
1211 PRT 201 20
1248 HRE
1285 HRE
1322 HRE

 
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
Pick a Random name from a list. David M Fritzke Excel Discussion (Misc queries) 7 September 30th 08 05:11 PM
need to set up a formula to pick random numbers Joe Excel Worksheet Functions 3 September 9th 08 09:10 PM
Random pick of a cell saman110 via OfficeKB.com Excel Discussion (Misc queries) 5 August 2nd 07 12:30 AM
Pick a Random name from a list. David M Fritzke Excel Worksheet Functions 5 August 25th 06 03:11 PM
random pick names from the list jinvictor Excel Discussion (Misc queries) 1 June 26th 06 03:00 PM


All times are GMT +1. The time now is 04:44 AM.

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

About Us

"It's about Microsoft Excel"