Consulting

Results 1 to 5 of 5

Thread: duplicate records extraction with percentage requirement

  1. #1
    VBAX Newbie
    Joined
    Oct 2012
    Posts
    4
    Location

    Unhappy 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

  2. #2
    VBAX Mentor
    Joined
    Jul 2012
    Posts
    398
    Location
    attach a sample file with data and desired result

  3. #3
    VBAX Newbie
    Joined
    Oct 2012
    Posts
    4
    Location

    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
    Attached Files Attached Files

  4. #4
    VBAX Tutor mohanvijay's Avatar
    Joined
    Aug 2010
    Location
    MADURAI
    Posts
    268
    Location
    Why don't you use pivot table?

  5. #5
    VBAX Mentor Teeroy's Avatar
    Joined
    Apr 2012
    Location
    Sydney, Australia
    Posts
    414
    Location
    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.
    Attached Files Attached Files
    _________________________________________________________________________
    "In theory there is no difference between theory and practice. In practice there is." - Chuck Reid

    Any day you learn something new is a day not wasted.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •