+ Reply to Thread
Results 1 to 4 of 4

Finding unique values and their count

  1. #1
    Forum Contributor
    Join Date
    07-25-2008
    Location
    texas
    Posts
    178

    Finding unique values and their count

    How can I find the unique values in a column , remove the dups, and leave the count in the next column?

    Example:

    A
    A
    A
    B
    B
    B
    B
    C
    C

    gives:
    A 3
    B 4
    C 2


    I only know the manual SUBTOTAL method then copy values to a new worksheet,... - real ugly.

  2. #2
    Valued Forum Contributor Shijesh Kumar's Avatar
    Join Date
    05-26-2008
    Location
    Bangalore / India
    MS-Off Ver
    2000
    Posts
    717
    Create a pivot


    Best and Easy

  3. #3
    Forum Contributor
    Join Date
    07-25-2008
    Location
    texas
    Posts
    178
    Of course. I completely forgot about those. Too busy looking for VB script solution.
    Can I run a pivot table from a macro?

    Thanks

  4. #4
    Valued Forum Contributor Shijesh Kumar's Avatar
    Join Date
    05-26-2008
    Location
    Bangalore / India
    MS-Off Ver
    2000
    Posts
    717
    Yes you can run pivot table from macros..
    But that required very rarly..

    U can create a pivot and keep on adding or deleting or modifiyt the data and click on refresh pivot to refresh the data

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1