Q:

In Excel, how to check if three values are present on the same line

In Excel, I am doing a planning with different shifts for all the employees, one line per day.
I'd like to have, as a last column, a "check shift", that will be a cell saying OK if there's the three shifts we have.
For example, for a particular day, we'll have 5 people working, one will be morning, 3 will be mid-day, one will be night
If we have the three values (morning, mid-day, night) on the line, then the check cell will mark OK. Otherwise, KO.
Any clue ?

A:

Based on data in A2:J2, in K2:
=IF(MIN(COUNTIF(A2:J2,{"morning","mid-day","night"})),"OK","KO")
Copy down to give similar results for row 3, row 4, etc.
Regards

