Forum Discussion
Andrew_Hinson
Feb 21, 2024Brass Contributor
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 ...
OliverScheurich
Feb 21, 2024Gold Contributor
=MIN(INDEX(E63:E377,MATCH(TODAY(),A63:A377,0)):INDEX(E63:E377,315))
This should return the intended result if i correctly understand what you are looking for.
Andrew_Hinson
Feb 22, 2024Brass Contributor
Hi Oliver,
Thank you for your kind solution. I have followed that formula to the letter and it seems to be working!
Thank you again 🙂
Thank you for your kind solution. I have followed that formula to the letter and it seems to be working!
Thank you again 🙂