List Names in Chronological Order With Duplicate Dates

KnightFhawker

New Member
Joined
Dec 7, 2016
Messages
13
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!

CountNameDateSorted DateDate CountName (By Date)
1Name A2/5/171/18/171
2Name B3/1/172/5/171
3Name C4/1/173/1/171
4Name D5/1/173/20/171
5Name E8/1/174/1/171
6Name F9/1/174/1/172
7Name G1/18/174/1/173
8Name H4/1/175/1/171
9Name I3/20/175/1/172
10Name J4/1/176/20/171
11Name K5/1/177/15/171
12Name L6/2/178/1/171
13Name M7/15/179/1/171

<tbody>
</tbody>
 

Some videos you may like

Excel Facts

Best way to learn Power Query?
Read M is for (Data) Monkey book by Ken Puls and Miguel Escobar. It is the complete guide to Power Query.

Eric W

MrExcel MVP
Joined
Aug 18, 2015
Messages
10,633
Try:

ABCDEF
1CountNameDateSorted DateDate CountName (By Date)
21Name A2/5/20171/18/20171Name G
32Name B3/1/20172/5/20171Name A
43Name C4/1/20173/1/20171Name B
54Name D5/1/20173/20/20171Name I
65Name E8/1/20174/1/20171Name C
76Name F9/1/20174/1/20172Name H
87Name G1/18/20174/1/20173Name J
98Name H4/1/20175/1/20171Name D
109Name I3/20/20175/1/20172Name K
1110Name J4/1/20176/2/20171Name L
1211Name K5/1/20177/15/20171Name M
1312Name L6/2/20178/1/20171Name E
1413Name M7/15/20179/1/20171Name F

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

Array Formulas
CellFormula
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

New Member
Joined
Dec 7, 2016
Messages
13
That worked Beautifully! Thank you so much Eric! I really appreciate it.

Cheers!

Best Regards,

KnightFhawker
 

Watch MrExcel Video

Forum statistics

Threads
1,122,991
Messages
5,599,235
Members
414,297
Latest member
dalkarl

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top