#### weetamc

##### New Member
Good morning everyone, I hope this is the place I can get some help with this....ill try to keep this problem short:

I have a spreadsheet for absence. Our corporate trigger levels where an employee progresses to a stage of absence are 6 days in a row,4 weeks in a row, 3 months in a row and or four separate absences within a rolling year. Now the sheet I have set up every time someone is absent I type the number 1 into the cell corresponding to the date and i have it counting the number of days absent in another cell. What i would like to do (if this is possible) is to have a pop up message appear when the count reaches 6 days and or 4 seperate occasions (this would need to somehow count any absences under six days as one absence until this reaches four?)
I know its all very confusing if you think your able to offer me some help i will try to simplify the explanation....one massive thanks in advance...

Tam
Scotland

### Excel Facts

Back into an answer in Excel
Use Data, What-If Analysis, Goal Seek to find the correct input cell value to reach a desired result

#### Steve_

##### Board Regular
Good morning everyone, I hope this is the place I can get some help with this....ill try to keep this problem short:

I have a spreadsheet for absence. Our corporate trigger levels where an employee progresses to a stage of absence are 6 days in a row,4 weeks in a row, 3 months in a row and or four separate absences within a rolling year. Now the sheet I have set up every time someone is absent I type the number 1 into the cell corresponding to the date and i have it counting the number of days absent in another cell. What i would like to do (if this is possible) is to have a pop up message appear when the count reaches 6 days and or 4 seperate occasions (this would need to somehow count any absences under six days as one absence until this reaches four?)
I know its all very confusing if you think your able to offer me some help i will try to simplify the explanation....one massive thanks in advance...

Tam
Scotland

Could you show me some example data please? I need to see the formatting of your sheet. But yes, I can do this easily.

Replies
1
Views
506
Replies
2
Views
439
Replies
22
Views
1K
Replies
3
Views
406
Replies
1
Views
96

1,141,704
Messages
5,707,966
Members
421,538
Latest member
Krisco

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back