I am aware that the MIN function in Excel returns the min value in a defined range. What Im trying to do is to return the min value of a rolling time period. Let me explain. I have two columns: date and withdrawals (in dollars). The date starts 10 years ago. Lets just say the date range is Jan 1, 2008 to Dec 31, 2017. Some days there is a withdrawal amount. I want to know the largest withdrawal (which is a negative number, hence why Im looking to use the MIN function) on a particular date from the start of the date range to that date. I dont want to consider the entire range but rather a rolling date range. Below is a clearer example.
Date Withdrawal Largest Withdrawal (so far) Formula
Jan 1, 2008 ($5) ($5) =MIN(B2)
Jan 2, 2008 ($25) ($25) =MIN(B2:B3)
Jan 3, 2008 0 ($25) =MIN(B2:B4)
Jan 4, 2008 ($100) ($100) =MIN(B2:B5)
Jan 5, 2008 ($20) ($100) =MIN(B2:B6)
By now, Im sure you get a clearer picture. Rather than do this manually (for some accounts there are thousands of cells), how do I do this in an automated way?
Thanks in advanced.
Date Withdrawal Largest Withdrawal (so far) Formula
Jan 1, 2008 ($5) ($5) =MIN(B2)
Jan 2, 2008 ($25) ($25) =MIN(B2:B3)
Jan 3, 2008 0 ($25) =MIN(B2:B4)
Jan 4, 2008 ($100) ($100) =MIN(B2:B5)
Jan 5, 2008 ($20) ($100) =MIN(B2:B6)
By now, Im sure you get a clearer picture. Rather than do this manually (for some accounts there are thousands of cells), how do I do this in an automated way?
Thanks in advanced.
