F
Frador
How can I make it so Excel checks a column to see if the are an exact set of
entries in a column, in no particular order, and with empty cells. I'm doing
a schedule, and none of the templates I've found work for me. Each column
represents either a day or night shift, and I need to be sure I've scheduled
enough people. I have to enter a variety of jobs and starting times with no
set ending times. I need a formula that will let me know if I've got all the
staff I need. Any ideas? I'm thinking it's some sort of combination of "and",
"count" and "countif", but I can's quite figure it out.
entries in a column, in no particular order, and with empty cells. I'm doing
a schedule, and none of the templates I've found work for me. Each column
represents either a day or night shift, and I need to be sure I've scheduled
enough people. I have to enter a variety of jobs and starting times with no
set ending times. I need a formula that will let me know if I've got all the
staff I need. Any ideas? I'm thinking it's some sort of combination of "and",
"count" and "countif", but I can's quite figure it out.