BradRichardson
New Member
- Joined
- Sep 17, 2016
- Messages
- 2
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!
Moderator note:
Cross-posted here: http://www.msofficeforums.com/excel/33678-create-unique-list-values-match-criteria-sorted.html
Please read the forum rules, especially regarding cross-posting, and follow them in future. Thanks.
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!
Moderator note:
Cross-posted here: http://www.msofficeforums.com/excel/33678-create-unique-list-values-match-criteria-sorted.html
Please read the forum rules, especially regarding cross-posting, and follow them in future. Thanks.
Last edited by a moderator:
