I am trying to create a series of formulas that will automatically review the information held on the "KI" worksheet and display information on "KIS Out of date" worksheet.
The dates in Column F of "KI" worksheet relate to an action, that action has to take place by the date in that cell. The KI worksheet would typically contain over 1000 entries.
I am looking for a way to have the "KIS out of date" page display the actions that are close to (30 days) or are out of date and display them, oldest date first in descending order (so the most out of date is at the top).
I've worked out a way to display them by mutilating a formula I made for something else a while ago I just cant work out how to do it in descending order.
Any and all help is greatly appreciated.
Here is a link for the file
https://www.box.com/s/66f7502d4b54d651db9d
The dates in Column F of "KI" worksheet relate to an action, that action has to take place by the date in that cell. The KI worksheet would typically contain over 1000 entries.
I am looking for a way to have the "KIS out of date" page display the actions that are close to (30 days) or are out of date and display them, oldest date first in descending order (so the most out of date is at the top).
I've worked out a way to display them by mutilating a formula I made for something else a while ago I just cant work out how to do it in descending order.
Any and all help is greatly appreciated.
Here is a link for the file
https://www.box.com/s/66f7502d4b54d651db9d