COUNTIF - FIRST OCCURRENCE ONLY

Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: COUNTIF - FIRST OCCURRENCE ONLY

  1. #1
    New Member
    Join Date
    May 2005
    Location
    Melbourne
    Posts
    5
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default COUNTIF - FIRST OCCURRENCE ONLY

     
    Hi all,
    I've searched help on countif with no luck so far, so I am not sure if I'm on the right track.
    I have 714 records with an alpha/numeric reference code in column A. This code may appear several times in that column however I only want to count the first occurrence along with all the unique ones. Ie. The total number of different codes used, whether they appear more than once or not is irrelevent. Hope I have made sense and that someone out there can help. Thanks.
    Regards,
    Cheryl.

  2. #2
    MrExcel MVP
    Join Date
    May 2002
    Posts
    14,181
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    hi - welcome to the board!

    do a search for 'count distinct' or 'count unique' - here's one to get you started:

    http://www.mrexcel.com/board2/viewtopic.php?t=73502

    ..post back if you can't get it sorted.

  3. #3
    New Member
    Join Date
    May 2005
    Location
    Melbourne
    Posts
    5
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    Hi Paddy,
    Thanks for your help. I found a post from someone with the same problem. Formula as follows:

    =SUMPRODUCT((A7:A721<>"")/COUNTIF(A7:A721,A7:A721&""))

    Thanks again.

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com