MIN Function (or is there a better way)

mneghassi

New Member
Joined
Jul 17, 2018
Messages
18
I am aware that the MIN function in Excel returns the min value in a defined range. What I’m 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. Let’s 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 I’m looking to use the MIN function) on a particular date from the start of the date range to that date. I don’t 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, I’m 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.
 

Excel Facts

When did Power Query debut in Excel?
Although it was an add-in in Excel 2010 & Excel 2013, Power Query became a part of Excel in 2016, in Data, Get & Transform Data.
I spaced out the columns a bit so that it's much easier to read

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)
 
Upvote 0
Take 3. Sorry for the extra replies.

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)
 
Upvote 0

Forum statistics

Threads
1,224,884
Messages
6,181,555
Members
453,053
Latest member
Kiranm13

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top