KnightFhawker
New Member
- Joined
- Dec 7, 2016
- Messages
- 17
- Office Version
- 365
- 2016
- Platform
- Windows
- Mobile
- Web
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!
<tbody>
</tbody>
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>