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!
Count of times name is in list - SOLVED!
-
- 3StarLounger
- Posts: 254
- Joined: 01 Mar 2010, 17:34
- Location: Blue Springs, MO
Count of times name is in list - SOLVED!
Last edited by Abraxus on 29 Sep 2021, 17:40, edited 1 time in total.
Morgan
-
- 3StarLounger
- Posts: 264
- Joined: 04 Oct 2017, 15:47
Re: Count of times name is in list
you could try this.
=IF(A2<>"",COUNTIF($A$2:A2,A2),"")
Adeel
=IF(A2<>"",COUNTIF($A$2:A2,A2),"")
Adeel
-
- 3StarLounger
- Posts: 254
- Joined: 01 Mar 2010, 17:34
- Location: Blue Springs, MO