Random Sampling rows
 

Hi

I have an excel sheet with data in range A1:G1000. I need a random
sampling function to just highlight say about 5% of the rows in a
different colour, or show them on a different cell range in the same
sheet.

i tried using RAND() but it doesnt seem like what I am looking for.

Cheers
Sunny

Random Sampling rows
 

in H1 to h1000 put the formula =randbetween(1,20)

Then conditionally format your cells in columns A-G with

if H (row num) =1

and set format cells patterns to colour cells red.

you can choose any number between 1 and 20 in your formula, obviously.


--
robert111
------------------------------------------------------------------------
robert111's Profile: http://www.excelforum.com/member.php...o&userid=31996
View this thread: http://www.excelforum.com/showthread...hreadid=522532

Random Sampling rows
 

This works fine. Thanks Robert.