Afternoon,
I have been fruitlessly searching for a way to do this, i've partially managed to work it but cannot get any further.
I have a spreadsheet where i log FoI requests. These have a 20 day time limit and we send reminders out after 10, 15, 17, 19 20 (due) & 21 (overdue) days. I am trying to create a list on a seperate tab of all those that are within their reminder period but haven't been closed or sent a reminder.
I have used the following formula:
<TBODY>
</TBODY><COLGROUP><COL></COLGROUP>
I have been fruitlessly searching for a way to do this, i've partially managed to work it but cannot get any further.
I have a spreadsheet where i log FoI requests. These have a 20 day time limit and we send reminders out after 10, 15, 17, 19 20 (due) & 21 (overdue) days. I am trying to create a list on a seperate tab of all those that are within their reminder period but haven't been closed or sent a reminder.
I have used the following formula:
INDEX(RequestLog!B11:AC1008,MATCH(1,(RequestLog!AD11:AD1008="")*(RequestLog!Y11:Y1008="")*(RequestLog!B11:B1008<11)*(RequestLog!B11:B1008>5),0),2) </SPAN> This will show me the first instance of a reference needed a reminder at the 10 day point (i have managed to modify this for the other reminder points). I now want to combine this with the SMALL & ISERROR functions, copy it down, and produce a list. Is anybody able to help me ? I have pasted below an extract from the main table (this shows column B through to AD, what is shown as a P should be in Wingdings and show a tick)
<TBODY> </TBODY><COLGROUP><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL span=8><COL><COL><COL><COL><COL span=2><COL span=5><COL></COLGROUP> Thanks a million in advance... |
<TBODY>
</TBODY><COLGROUP><COL></COLGROUP>