Number the occurrences

Hello everyone,

In Excel 2003, I am looking to number the occurrences... In one column, I have a list of names, and these names may appear multiple times if the people are registered for several activities.
I would like to note 1 the first time the name appears, then 2, then 3, etc... or alternatively note 1 the first time, and then 0 for all the other times the same name reappears.
After a few hours of fruitless searching, I am reaching out.
Thank you very much

Nicole
Configuration: Windows XP / Firefox 3.6

2 answers

  • Votes
  • Date
  • Descending date
  1. Hello,

    This is the COUNTIF function

    For example, if you want to count the Duponts in the range A2 to A20
    =COUNTIF(A2:A5,"Dupont")

    However, if the cells contain both first and last names, for example, and you want to still count Duponts
    =COUNTIF(A2:A20,"*Dupont*")
    --
    Cheers,
    Mike-31

    A period of failure is a perfect moment to sow the seeds of knowledge.
    1. Thank you for your quick response,
      I have already used the following formula: =SUM(1/COUNTIF(Name;Name))
      Certainly, it gives me the number of unique names.
      Actually, I would like to be able to automatically number each person
      Example:
      DUPONT Jacques has number 1
      MACHIN Léon has number 2
      |
      |
      CHOSE Bidule has number 58
      If DUPONT Jacques reappears, he should again have number 1

      Thanks again