Jun 13 2019 11:49 AM
I have a spreadsheet/calendar with employee names on the days they are taking off for vacation.
I am trying to find a way to have a count of how many times a name appears in any cell even if it already contains other names.
I could have 4 guys taking the same day off but I cannot seem to create a formula to have it count the name.
Thanks in Advance.
Jun 13 2019 01:36 PM
Jun 14 2019 04:45 AM
Jun 14 2019 04:53 AM
Jun 14 2019 05:58 AM
@Sergei Baklan I have attached the file for your reference.
I need to know how many times an employee's name appears in a cell.
I tried your formula and it did not work for me.
Jun 14 2019 06:52 AM
Try this:
=COUNTIF(A2:Y55,"*EMPLOYEE NAME HERE*")
@nicklesontool
Jun 14 2019 08:22 AM