Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    Dec 2001
    Location
    Forres, Moray, Scotland
    Posts
    20
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Counting Names (Excel 2000)

    Hello, apologies if this has been asked before.
    I have a column of names, some repeated, some unique. Is there a simple way to count the number of first occurrence of names in the column?

    Many thanks in advance,

    John Hunting
    Forres, Scotland

  2. #2
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Counting Names (Excel 2000)

    Hi,
    See the link in <post#=406964>post 406964</post#> from <!profile=Tony55>Tony55<!/profile>
    Regards,
    Rudi

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 28 Times in 28 Posts

    Re: Counting Names (Excel 2000)

    Say that your names are in A1:A100. The following formula, entered as an array formula (i.e. confirm with Ctrl+Shift+Enter) will count the number of unique entries:

    =SUM(IF(LEN(A1:A100),1/COUNTIF(A1:A100,A1:A100)))

    This formula will work even if there are blank cells in the range. Formula courtesy of <!profile=Aladin Akyurek>Aladin Akyurek<!/profile>.

  4. #4
    Star Lounger
    Join Date
    Feb 2003
    Posts
    89
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Counting Names (Excel 2000)

    A non array also by Aladin,

    =SUMPRODUCT((A1:A3<>"")/COUNTIF(A1:A3,A1:A3&""))

Posting Permissions

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