Create a unique list of values that match a criteria, sorted in order of another criteria

[BradRichardson]

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,COUNTIF($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!

 

[John Jairo V]

Hi @BradRichardson !

Next time, upload a file instead a picture, for check the answer with your data.
Check file with an example. Blessings!

 

[BradRichardson]

Hi @BradRichardson !

Next time, upload a file instead a picture, for check the answer with your data.
Check file with an example. Blessings!

Thanks for your response John. This gives the result I want, but the result is incomplete.

There are 17 rows in my data that occur on the 12/09, but only 14 of these rows are returned by your formula.

Any idea what might be causing this?

Thanks!
Brad

 

[John Jairo V]

There are 17 rows in my data that occur on the 12/09, but only 14 of these rows are returned by your formula.

Upload your data in an Excel file, and see what's going on. Blessings!