Perhaps this array formula:
=COUNT(1/FREQUENCY(IF(F21:AB21="SICK",COLUMN(F21:AB21)),IF(F21:AB21="DUTY",COLUMN(F21:AB21))))
Perhaps this array formula:
=COUNT(1/FREQUENCY(IF(F21:AB21="SICK",COLUMN(F21:AB21)),IF(F21:AB21="DUTY",COLUMN(F21:AB21))))
Everyone who confuses correlation and causation ends up dead.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks