Forum Discussion
Assign slots equally among employees with same assessment date
I have a sheet with employee data, and in column K, I've assigned them an assessment date. The employees are sorted by assessment date. The amount of employees per assessment date is more or less reg...
They are ranked in order of assessment date so the order should not be an issue. Is there a reference cell missing from this formula?
"order#" must be calculated. you can use something like COUNTIF($A$1:$A2,$A2) if row 1 is a header row and row 2 is the first data row and column A is the assigned day. (adjust accordingly). you could also use something like =IF(A1=A2,B1+1,1) with same assumptions as above plus this formula starts in B2 and that those assignment days are at least grouped.