Sort list into another list filtered low>high and only ones <90

In Sheet UD I have a list of contracts.

in sheet IN, I want them to sort with lowest first, and only show the ones that's to be renewed within 90 days.

It's a dynamic thing where the user will only see the IN - and the UD will be filled over time.

Much love

http://www.excelforum.com/attachment...1&d=1470680602

Originally Posted by GeneralDisarray

When you say 'lowest first' - which column are you referring to? Lowest NR?

Sorry

No column G

So the one with the least days untill is first

You can use a helper column to do that. See the attachment.

Alternatively, I think it can also be done without a helper column; try the formula below in sheet IN, cell A2. It's an array formula, so confirm it with Ctrl + Shift + Enter instead of the regular Enter. Fill it right through column G, then down through as many rows as you think you'll need. It should automatically update as you add entries to UD.

=IFERROR(INDEX(UD!$A$2:$G$200,SMALL(IF((UD!$G$2:$G$200<90)*(UD!$G$2:$G$200=SMALL(UD!$G$2:$G$200,ROW(1:1)))=1,ROW(UD!$G$2:$G$200)-1),1),COLUMN(A:A)),"")

Note that it's currently written to look at the first 200 rows of UD. If you need it to cover more rows, just change all of the "$200"s in the formula to something bigger.