Hi all,

I have following data on my excel sheet.

man
man
man
man
man
man
man
man
man
man
john
john
john
john
john
john
john
john
john
john
john
john
john
john
john
john
john
john
john
john

10 man cells are there, and 20 john cells are there.
i need 10% of this data.
it means 1 man, 2 john.

i need a vb program/macro to do this.

please help me...
Thanks in advance..

PRB