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 |