Count of times name is in list - SOLVED!

[Abraxus]

My wife has a list of employees where she records when they call in sick.

Is it possible to have a cell where after she enters their name, it shows how many times their name is on the list up to and including the most recent entry?

For example, the 1st time you enter Bob, it would show 1 while the 4th time it would show 4, but the 1 from the first time would remain 1...

Thanks!

[adeel1]

you could try this.

=IF(A2<>"",COUNTIF($A$2:A2,A2),"")

Adeel

[Abraxus]

you could try this.

=IF(A2<>"",COUNTIF($A$2:A2,A2),"")

Adeel

It worked perfectly, THANK YOU!