Duplicates, can I count the Original but ignore 2nd, 3rd etc

04/16/19 Edited 12/09/19

Hi

I had a look but couldn't find the answer.

I am trying to do simple reports and formula Counts, but trying to ignore any duplicates.

Example below, I am only interested in counting the first time a name appears, so the count would equal 5 Names, ignoring where there is a second or third.

Names

Andrew

Dave

Phil

Sarah

Phil

George

Dave

Dave

 

 

Comments

  • L_123L_123 ✭✭✭✭✭

    easiest way is a helper column

    first cell of the helper is:

    =if(countif(Names$1:Names1,[email protected])=1,1,0))

    Then its just an easy count formula

    =count(helper:helper)

  • Paul NewcomePaul Newcome ✭✭✭✭✭

    There is an extra closing Parenthesis tacked on to the end there...

     

    =IF(COUNTIF(Names$1:Names1, [email protected]) = 1, 1, 0)

    thinkspi.com

Sign In or Register to comment.