Dates start at K6 and go on until the new year. As you can imagine, that is a lengthy spreadsheet to scroll through. I have a summary section that tells me the amount but I need a fast way to also gather the dates. So maybe a summary of dates. So instead of having to scroll over 60 rows to get from July 1st to September 1st, I can see them next to each other if they occurrences that happen sequentially.
So something similar to like,
To make it REALLY convoluted, after time an attendance event rolls off, so in essence that date is worthless. Below is the formula used to give value to an absence or tardy. So ideally something similar for the dates would occur, that it would only list the dates with values. The biggest issues I can see that an "Excused Absence" is worth 0 points, but is still recorded.
I've attached a worksheet, the WANT tab essentially reflects what I am looking for.
I am also WAY open to suggestions on how to improve the sheet in general. Simpler the better so maybe I can understand some of it lol.
Sorry the second formula is broken up, it causes a firewall to block it because of "HTML CODE" No idea.
Bookmarks