View original (French)

Number the occurrences

nico5902 -  
nico5902 Posted messages 1 Status Member -
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

  1.
    Mike-31 Posted messages 18205 Registration date   Status Contributor Last intervention   5 147
     
    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.
    0
  2. nico5902 Posted messages 1 Status Member
     
    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
    0