Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Random and Lookup and Countif
Greetings All,
In Col A I have many different text entries such as Flightline, Avionics, Sheet Metal and text data in B1:AC1 down to 1700. I'm trying to count the amount of times that say, Flightline occurs. Then sample 10% of those instances in A1:A1700 and return the 10% and the associated row (?1:?1700) Say Flightline occurs 17 times in A1:A1700. I want to randomly select 2 of those rows in another worksheet. Can you help? -- Vick |
#2
|
|||
|
|||
Hi!
This is fairly easy to do but the explanation would be long and complicated. I put together a sample file that demonstrates how to do this. Let me know how to contact you and I'll send it to you. Don't trust files from unkown sources? I don't blame you! I'm a regular here. Do a search on my name and you'll see. Biff "arkansas ang analysis" wrote in message ... Greetings All, In Col A I have many different text entries such as Flightline, Avionics, Sheet Metal and text data in B1:AC1 down to 1700. I'm trying to count the amount of times that say, Flightline occurs. Then sample 10% of those instances in A1:A1700 and return the 10% and the associated row (?1:?1700) Say Flightline occurs 17 times in A1:A1700. I want to randomly select 2 of those rows in another worksheet. Can you help? -- Vick |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|