Sort dates in ascending order

[YasserKhalil]

Hello everyone
In my attachment I have two sheets one for data named "INT" and the other sheet is for results named "FEED"
In FEED sheet I have array formulas that extract the data between two dates in
Code:

Please Login or Register  to view this content.

Everything is ok

I need to have the results sorted according to the dates (in ascending order) using array formulas and without using helper columns ...
Thanks advanced

[Norie]

Why not use Excel's built in sorting functionality?

This is the kind of thing it's there for.

[FlameRetired]

If you still want array formula try array-entering this in the FEED sheet.

=IFERROR(SMALL(IF(($C$3<=INT!$C$5:$C$27)*($D$3>=INT!$C$5:$C$27),INT!$C$5:$C$27),ROWS($1:1)),"")

[YasserKhalil]

Thanks a lot for this great help
It is wonderful

Can you help me editing the formulas in Columns D & E to grab the proper data according to the date ..?

[YasserKhalil]

I tried to use this formula in D7

Please Login or Register  to view this content.

and this formula in E7

Please Login or Register  to view this content.

Everything is ok if I have different dates but I have problem with the same dates
For example : the date "02/02/2015" ...I have got Client 3 and 9000 for both the dates

[newdoverman]

The easiest way to get the dates in order on the FEED worksheet is to sort the dates in order on the INT worksheet. Your existing formula will not have to be adjusted and the dates will be in order.

[FlameRetired]

If you still want to use formula array-enter this as before. Find it in column H of FEED in the attached.

Please Login or Register  to view this content.

Then in column G array-enter this and fill down until you get blanks.

Please Login or Register  to view this content.

Then copy that range and paste into columns I and J.

[YasserKhalil]

Brilliant
Thanks a lot for this wonderful solution. You are perfect

[FlameRetired]

You are welcome. Glad it does the job.