Results 1 to 7 of 7

check value - merge and count

Threaded View

Armitage2k check value - merge and count 06-18-2009, 02:00 PM
pike Re: check value - merge and... 06-18-2009, 04:46 PM
Armitage2k Re: check value - merge and... 06-19-2009, 11:35 AM
pike Re: check value - merge and... 06-21-2009, 05:56 AM
pike Re: check value - merge and... 06-21-2009, 08:48 AM
pike Re: check value - merge and... 06-21-2009, 04:09 PM
pike Re: check value - merge and... 06-21-2009, 06:17 PM
  1. #1
    Forum Contributor
    Join Date
    03-24-2009
    Location
    Vietnam
    MS-Off Ver
    Excel 2010
    Posts
    382

    check value - merge and count

    Hello!

    I have following problem.
    I have a file with about 10,000 rows, each containing a column with a number, a date, text, text, number, number. that order, about 10,000 times.

    Now I have the great honor to check all these entries for duplicates (done), BUT, and this is where it gets tricky, some entries values are exactly the same.

    Example:

    A - B - C - D - E - F
    5 - 2009/01/01 - Bill Gates - Microsoft - 5 - 13
    5 - 2009/01/15 - Bill Gates - Microsoft - 6 - 17


    How do I manage to get Excel to count me that there are 2 entries, and then merge them together into one, but still showing me "2" in another colum?

    WANTED RESULT:
    A - B - C - D - E - F - H (!)
    10 - Date does not matter - Bill Gates - Microsoft - 11 - 30 - TOTAL 2 entries

    The date does not really matter and can actually be deleted. Anyway, I have been playing with CountIF but without success. any ideas?

    THANKS
    A2k
    Last edited by Armitage2k; 06-19-2009 at 11:36 AM.

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