Hi all,



I've been struggling with this question for a week.

In column E I have the following formula to create a distinct list of values in A for which the date in column B matches the date in E1. The formula is:

=INDEX($A$2:$A$976,MATCH(0,IF($E$1=$B$2:$B$976,COU NTIF($E$1:$E1, $A$2:$A$976),""),0))

This formula works.

What I want to do is sort the results of this formula based on the corresponding value in column C in ascending order.

In column G is the way it should look.

I also want to display those ascending column C values in column F. Column H is the way F should look.

Any ideas are greatly appreciated!

Attached Images

Screen Shot 2016-12-25 at 8.25.50 pm.png (68.1 KB, 20 views)