duplicate records extraction with percentage requirement
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 :banghead:
1 Attachment(s)
duplicate records extraction with percentage requirement Reply to Thread
Thanks for reply..
I have attached a file.
I need a macro to check the duplicates and extracts 10% of data in "C" column.
according to given data 1 man, 2 john should be the answer.
PRB:help