The sheet is protected so I can't do anything with it. However I suggest a helper column for each person with a formula like:
=IF(AND(NOT(ISBLANK(C2)),C2<>C1),1,0).
This formula checks to see that cell is not blank and that it is different than the cell above it. If this is true, then it is the start of an occurrence. You can then use this helper column in a SUMIFS formula to count absences by type. The helper columns can be hidden.
One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.
A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.
Thanks dflak. If I need the formula to begin when any cell in Col D reaches >40, is would this be hard to write into the formula? BTW I think the password is phs for that sheet. I couldn't get it to open in Excel. Not familiar with how this site handles attachments. I appreciate your suggestion and will try it.
Doesn't work in this instance but I do like the use of IF(AND(NOT(ISBLANK all in a row!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks