Random Sampling rows

[sunilkeswani]

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

 

[robert111]

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.

 

[sunilkeswani]

This works fine. Thanks Robert.