Need help with counting duplicate numbers only once.

[anthoj92]

How do I make a formula that will count values in a column only once

I would like to look something like this:

Number Count
111 1
111 0
111 0
111 0
222 1
222 0
222 0
222 0
555 1
555 0
555 0
666 1
666 0
666 0


I would really appreciate some help, thanks!

[Richard Buttrey]

Hi and welcome to the (currently slow!) forum

Please Login or Register  to view this content.

copied down.

[Pete_UK]

Assuming your first number is in A2, you can put this formula in B2:

=--(COUNTIF(A$2:A2,A2)=1)

then copy down.

Hope this helps.

Pete

EDIT: You may have to use a semicolon ( ; ) instead of the comma ( , ) in the formula.

Pete

[anthoj92]

It works, thank you very much!!

[Pete_UK]

Glad to help.

If that takes care of your original question, please take a moment to select Thread Tools from the menu above your first post and mark this thread as SOLVED.

Also, since you are new to the forum, you might like to know that you can directly thank those who have helped you by clicking on the small "star" icon located in the lower left corner of a post that you have found to be helpful (not just in this thread - for any post that has helped you). This also adds to the reputation of the poster (the small green bars in the poster's profile).

Pete