Forum Discussion
Return Value Based on Latest Date
Hello, I'm trying to return a value based on the latest date which has duplicates For example... Date Balance 01/01/24 £100 02/01/24 £120 01/02/24 £200 01/03/24 £210 01/03/24...
=INDEX($B$2:$B$7,LARGE(IF($A$2:$A$7=D2,ROW($A$2:$A$7)-1),1))
This formula works in my sample file. The formula must be entered as an arrayformula with ctrl+shift+enter if someone doesn't work with Office 365 or Excel for the web or Excel 2021.
Sorry I should have mentioned, I don't want to use the latest date as criteria in your D2 preferably not an array either
I'm unsure if i correctly understand what you want to do. Perhaps the suggestions in the attached sample file are helpful. Otherwise could you add a few examples along with the expected result?
- So when entering new dates with balances, regardless if single or duplicate dates which it can handle, it would return the latest balance. I will always be entering dates oldest to newest/latest. Unfortunately none of the examples attached previously show what I'm after
