Forum Discussion
MIN function
Hi everyone, So, In column A I have the dates of 2024 in format ddd-dd-mmm-yy. In column E I have a bank balance, which changes daily depending on what transactions are put into a different ...
If I understand the data arrangment correctly, try this one:
=LET(
discard, XMATCH(TODAY(), A63:A377) - 1,
keep, DROP(E63:E377, discard),
MIN(keep)
)
Hi Patrick!
Thank you for coming back to me! I have tried Olivers solution above and it seems to be working. I usually like to try the different solutions I've got to see if I can understand how they are working, but I think with this it is far too complex!
I'll keep your solution in mind though 🙂
Thank you.
Thank you for coming back to me! I have tried Olivers solution above and it seems to be working. I usually like to try the different solutions I've got to see if I can understand how they are working, but I think with this it is far too complex!
I'll keep your solution in mind though 🙂
Thank you.