Forum Discussion

Andrew_Hinson's avatar
Andrew_Hinson
Brass Contributor
Feb 21, 2024

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 ...
excel
Patrick2788's avatar
Patrick2788
Silver Contributor
Feb 21, 2024

Andrew_Hinson 

If I understand the data arrangment correctly, try this one:

 

=LET(
    discard, XMATCH(TODAY(), A63:A377) - 1,
    keep, DROP(E63:E377, discard),
    MIN(keep)
)

 

 

  • Andrew_Hinson's avatar
    Andrew_Hinson
    Brass Contributor
    Feb 22, 2024
    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.

Resources