Forum Discussion
Adam08320
Jul 07, 2024Copper Contributor
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...
Adam08320
Copper Contributor
Sorry I should have mentioned, I don't want to use the latest date as criteria in your D2 preferably not an array either
OliverScheurich
Jul 07, 2024Gold Contributor
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?
- Adam08320Jul 07, 2024Copper ContributorSo 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