Hi everyone,
new to the forum and would like some guidance on some formula i am stuck on:
we have a large dataset which has some info re staff absence days , and looks like the below. what i am looking to do is increment by 1 each time the staff member in question is registered as being absent on non consecutive days.
i had tried earlier to add in a separate row with date absent column minus the earliest date recorded by employee name, which did work but meant i had to re align the date formula for each name.
the output i would hope to achieve is then build a table using all the employee names and then use the count results in the last column to do an overall result of occurnces of absences. something like a Max formula to see the occurences perhaps
any help appreciated, i am a stuck and cant get my head around how to build this one
thanks
<tbody>
</tbody>
new to the forum and would like some guidance on some formula i am stuck on:
we have a large dataset which has some info re staff absence days , and looks like the below. what i am looking to do is increment by 1 each time the staff member in question is registered as being absent on non consecutive days.
i had tried earlier to add in a separate row with date absent column minus the earliest date recorded by employee name, which did work but meant i had to re align the date formula for each name.
the output i would hope to achieve is then build a table using all the employee names and then use the count results in the last column to do an overall result of occurnces of absences. something like a Max formula to see the occurences perhaps
any help appreciated, i am a stuck and cant get my head around how to build this one
thanks
Name | Date absent | Occurrence |
John | 01/02/2019 | |
John | 02/02/2019 | |
John | 04/02/2019 | |
Steve | 01/03/2019 | |
Steve | 02/03/2019 | |
Steve | 04/03/2019 | |
<tbody>
</tbody>