Number the occurrences
nico5902
-
nico5902 Posted messages 1 Status Member -
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
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
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.
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.
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
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