+ Reply to Thread
Results 1 to 3 of 3

Excel 2007 : Headcount unique names

  1. #1
    Registered User
    Join Date
    01-28-2011
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    26

    Headcount unique names

    Hi, can anyone help with this please?

    I have list of names that need to be counted, however some names appear twice. How can I do a headcount of individual names in the list, assigning a number to every unique name only (in a separate column).

    Thanks
    Last edited by daniel_t; 01-31-2011 at 11:12 AM.

  2. #2
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    21,528

    Re: Headcount unique names

    If you intend to assign a number do this first, the count is then the MAX of the numbers.

    Are you names sorted ?

    If we assume unsorted then with nmes in A2 onwards

    Please Login or Register  to view this content.
    If names are sorted

    Please Login or Register  to view this content.
    either way count of unique names is:

    Please Login or Register  to view this content.
    If you want to count unique without the numbers then:

    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    01-28-2011
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    26

    Re: Headcount unique names

    Thanks DonkeyOte, =SUM($B1,$A2<>$A1) worked perfectly.

    Daniel

+ 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