Hi All
Thanx for a great forum.
I have two columns, the first with random dates (can be repeated), and the second with different text values that is repeated randomly:
A B C (I need formula to give below results - last date)
2021/12/02 Charlie 2022/01/03
2021/12/05 Bravo 2022/01/02
2021/12/29 Charlie 2022/01/03
2022/01/02 Alpha 2022/01/04
2022/01/02 Bravo 2022/01/02
2022/01/03 Charlie 2022/01/03
2022/01/04 Alpha 2022/01/04
Will it be possible to have a formula if the dates are in random order (not required)?
Thanx in advance
Corne
Thanx for a great forum.
I have two columns, the first with random dates (can be repeated), and the second with different text values that is repeated randomly:
A B C (I need formula to give below results - last date)
2021/12/02 Charlie 2022/01/03
2021/12/05 Bravo 2022/01/02
2021/12/29 Charlie 2022/01/03
2022/01/02 Alpha 2022/01/04
2022/01/02 Bravo 2022/01/02
2022/01/03 Charlie 2022/01/03
2022/01/04 Alpha 2022/01/04
Will it be possible to have a formula if the dates are in random order (not required)?
Thanx in advance
Corne