Hi, I am creating a training tracker for my company. The current program uses 1's to delineate certified employees. These are the headers to my Table
The columns in orange indicate a task to be certified in.
My company has asked me to track the %trained for each shift. (1st,2nd,3rd) Is there a way for me to pull the rows of employees based on their shift? Then I can use the function
to calculate percentage of employees trained per shift
'Extractedrows' = Numbers of rows that include either '1st', '2nd', or '3rd' shifts
As variant that could be
where for example first range is C2:C100 and second one E2:E100. Similar to calculate blank cells, just change <> on = .