Printable View
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:
attach a sample file with data and desired result
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
Why don't you use pivot table?
Hi punna111,
Have a look at the attached spreadsheet. The code looks excessive because I used Functions I already had (both mine and from CPearson's site) to handle the bulk of the work and they are general rather than specific.