Hello, I’m trying to return a value based on the latest date which has duplicates

For example…

DateBalance01/01/24£10002/01/24£12001/02/24£20001/03/24£21001/03/24£22001/03/24£230

Date DD/MM format
As there can be multiple transactions on the same day
So I’m trying to return the last value £230
I’ve looked online but couldn’t find a clear enough solution
Office Pro Plus 2021
Please advise & thank you for your time

​Hello, I’m trying to return a value based on the latest date which has duplicatesFor example…DateBalance01/01/24£10002/01/24£12001/02/24£20001/03/24£21001/03/24£22001/03/24£230Date DD/MM formatAs there can be multiple transactions on the same daySo I’m trying to return the last value £230I’ve looked online but couldn’t find a clear enough solutionOffice Pro Plus 2021Please advise & thank you for your time  Read More

​