Below is a simple table. I would like to know of a formula that will look for the latest date within a row, taking into consideration of matching dates, and return the farthest right header.
<colgroup><col><col span="4"></colgroup><tbody>
</tbody>
Thus, column next to HD4 should look like this:
FORMULA
HD4
HD2
HD3
HD2
Thank you!
Dates | HD1 | HD2 | HD3 | HD4 |
1st | 1/1/2018 | 1/2/2018 | 1/2/2018 | 1/2/2018 |
2nd | 2/5/2018 | 2/5/2018 | ||
3rd | 1/15/2018 | 1/16/2018 | 1/16/2018 | |
4th | 2/26/2018 | 2/26/2018 |
<colgroup><col><col span="4"></colgroup><tbody>
</tbody>
Thus, column next to HD4 should look like this:
FORMULA
HD4
HD2
HD3
HD2
Thank you!