Complicated sorting and referencing formula

HolyLemon

New Member
Joined
May 13, 2010
Messages
46
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
 

Excel Facts

Excel Joke
Why can't spreadsheets drive cars? They crash too often!

Watch MrExcel Video

Forum statistics

Threads
1,129,816
Messages
5,638,496
Members
417,029
Latest member
lingx86

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Top