List Names in Chronological Order With Duplicate Dates

[KnightFhawker]

Hi everyone!

I hope someone can help me get to the final step. Using a formula, most likely an array, I would like to reorder my list of names in chronological order (by date). I have already created columns of data that I believe would get me to the final step, but I can't seem to finalize the formula with the correct structure. Based on the columns I have included as an example below, the Name (By Date) column is the one I need to find a formula for to get the Name Column in Date order, essentially matching the order of the Sorted Date column. If you can help I would greatly appreciate it. Thanks in advance!

Count	Name	Date	Sorted Date	Date Count	Name (By Date)
1	Name A	2/5/17	1/18/17	1
2	Name B	3/1/17	2/5/17	1
3	Name C	4/1/17	3/1/17	1
4	Name D	5/1/17	3/20/17	1
5	Name E	8/1/17	4/1/17	1
6	Name F	9/1/17	4/1/17	2
7	Name G	1/18/17	4/1/17	3
8	Name H	4/1/17	5/1/17	1
9	Name I	3/20/17	5/1/17	2
10	Name J	4/1/17	6/20/17	1
11	Name K	5/1/17	7/15/17	1
12	Name L	6/2/17	8/1/17	1
13	Name M	7/15/17	9/1/17	1

<tbody>
</tbody>

 

[Eric W]

Try:

	A	B	C	D	E	F
1	Count	Name	Date	Sorted Date	Date Count	Name (By Date)
2	1	Name A	2/5/2017	1/18/2017	1	Name G
3	2	Name B	3/1/2017	2/5/2017	1	Name A
4	3	Name C	4/1/2017	3/1/2017	1	Name B
5	4	Name D	5/1/2017	3/20/2017	1	Name I
6	5	Name E	8/1/2017	4/1/2017	1	Name C
7	6	Name F	9/1/2017	4/1/2017	2	Name H
8	7	Name G	1/18/2017	4/1/2017	3	Name J
9	8	Name H	4/1/2017	5/1/2017	1	Name D
10	9	Name I	3/20/2017	5/1/2017	2	Name K
11	10	Name J	4/1/2017	6/2/2017	1	Name L
12	11	Name K	5/1/2017	7/15/2017	1	Name M
13	12	Name L	6/2/2017	8/1/2017	1	Name E
14	13	Name M	7/15/2017	9/1/2017	1	Name F

<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>

Sheet27​

Array Formulas Cell Formula F2 {=INDEX($B$2:$B$14,SMALL(IF($C$2:$C$14=SMALL($C$2:$C$14,ROWS($F$2:$F2)),ROW($C$2:$C$14)-ROW($C$2)+1),COUNTIF($D$2:$D2,D2)))} <thead> </thead><tbody> </tbody> Entered with Ctrl+Shift+Enter. If entered correctly, Excel will surround with curly braces {}. Note: Do not try and enter the {} manually yourself

<tbody>
</tbody>

Column D is used in this formula, but not column E. You can shorten the formula a bit if you want to use column E. Replace the COUNTIF at the end with E2:

=INDEX($B$2:$B$14,SMALL(IF($C$2:$C$14=SMALL($C$2:$C$14,ROWS($F$2:$F2)),ROW($C$2:$C$14)-ROW($C$2)+1),E2))
With Control+Shift+Enter

 

[KnightFhawker]

That worked Beautifully! Thank you so much Eric! I really appreciate it.

Cheers!

Best Regards,

KnightFhawker

 

[Eric W]

Happy to help!