Produce a "To do..." list using Index/Match/Small functions...

[IainG84]

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:

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) Days remaining</SPAN> Ref</SPAN> Date received</SPAN> Response Due</SPAN> Acknowledged</SPAN> Source</SPAN> Method</SPAN> # Qs</SPAN> Description</SPAN> Mid</SPAN> West</SPAN> NEE</SPAN> CP&R</SPAN> BB</SPAN> Thurrock</SPAN> Southend</SPAN> CSU</SPAN> CCG or CSU Service</SPAN> Sent to Service</SPAN> Services involved</SPAN> Clarification?</SPAN> Clarification Received</SPAN> Revised Dealine</SPAN> 10 Day</SPAN> 15 Day</SPAN> 17 Day</SPAN> 19 Day</SPAN> Overdue</SPAN> Response</SPAN> -160</SPAN> 1314381 [R1]</SPAN> 01/04/14</SPAN> 01/05/14</SPAN> Individual</SPAN> Email</SPAN> Telephony, Broadband & WAN - Internal Review</SPAN> P</SPAN> P</SPAN> P</SPAN> P</SPAN> 27/01/00 P Disclosed</SPAN> -160</SPAN> F1415001</SPAN> 01/04/14</SPAN> 01/05/14</SPAN> 02/04/14</SPAN> Individual</SPAN> Email</SPAN> 8</SPAN> Mobile Phone Contracts</SPAN> P</SPAN> P</SPAN> P</SPAN> P</SPAN> P</SPAN> P</SPAN> P</SPAN> CSU</SPAN> 02/04/14</SPAN> 27/01/00 Info Not Held</SPAN> -159</SPAN> F1415002</SPAN> 02/04/14</SPAN> 02/05/14</SPAN> 04/04/14</SPAN> Media Email</SPAN> 3</SPAN> Quality Premium Payment & Dementia</SPAN> P</SPAN> P</SPAN> P</SPAN> P</SPAN> P</SPAN> P</SPAN> Both</SPAN> 04/04/14</SPAN> MH, Liaisons</SPAN> 27/01/00 P P Disclosed</SPAN> -159</SPAN> F1415003</SPAN> 02/04/14</SPAN> 02/05/14</SPAN> 04/04/14</SPAN> Individual</SPAN> Email</SPAN> 1</SPAN> IVF Funding</SPAN> P</SPAN> CSU</SPAN> 04/04/14</SPAN> IFR</SPAN> 27/01/00 Disclosed</SPAN> -158</SPAN> F1415004</SPAN> 03/04/14</SPAN> 06/05/14</SPAN> 04/04/14</SPAN> MP</SPAN> Email</SPAN> 4</SPAN> Named GPs for over 75's</SPAN> P</SPAN> P</SPAN> P</SPAN> P</SPAN> P</SPAN> P</SPAN> P</SPAN> 27/01/00 P Part Disclosed</SPAN> -167</SPAN> F1415005</SPAN> 04/04/14</SPAN> 18/04/14</SPAN> NHS England</SPAN> Email</SPAN> 18</SPAN> Telephony, Broadband & WAN</SPAN> P</SPAN> CSU</SPAN> 04/04/14</SPAN> ICT</SPAN> 27/01/00 Disclosed</SPAN> <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>

 

[IainG84]

I've still been trying to do this, but really cannot make it work. Just bumping in the hope someone can help.... Thanks