How to extract minimum value and show in another cell based on drop down list

[munchems]

Hello,

I'm a beginner excel user and I am trying to take the minimum value from the "New Amount Owing" column in Week 1 and show it in the "Amount Owing" column Week 2 based on the drop down list selection in the "Debt" column of Week 2. I've tried nesting IF and MINIF but haven't been sucsessful. TIA!

 

[munchems]

No, that was one of the first things I tried. The reason it doesn't work is because there's no condition on what drop down list selection is chosen in column A.

Yeah so that's exactly what I ended up using after I had posted my solution. I think coming up with that long formula helped me to understand how I could shorten it into a single MINIFS formula. But now I understand the AGGREGATE function as well and I'm learning a lot!! Thanks again!

You're welcome, but to be honest, I probably should have stuck to MINIFS that you were using. Wouldn't this very simple version of that function do the job for you?

23 11 15.xlsm
	A	B	C	D	E	F	G
3	Toll Hwy	111.14			35.00		76.14
4	Credit Card	663.00			35.00		628.00
5	Mortgage	1,500.00			20.00		1,480.00
6	Federal Student Loan	13,608.55			100.00		13,508.55
7	Credit Card	628.00			20.00		608.00
8	Mortgage	1,480.00			60.00		1,420.00
9	Credit Card	608.00			20.00		588.00
Lowest values (2)

Cell Formulas
Range	Formula
B7:B9	B7	=MINIFS(G$3:G6,A$3:A6,A7)
G3:G9	G3	=B3-E3

Sorry that first part of my reply was meant for another forum and I guess I thought I was typing there lol

 

[munchems]

You're welcome, but to be honest, I probably should have stuck to MINIFS that you were using. Wouldn't this very simple version of that function do the job for you?

23 11 15.xlsm
	A	B	C	D	E	F	G
3	Toll Hwy	111.14			35.00		76.14
4	Credit Card	663.00			35.00		628.00
5	Mortgage	1,500.00			20.00		1,480.00
6	Federal Student Loan	13,608.55			100.00		13,508.55
7	Credit Card	628.00			20.00		608.00
8	Mortgage	1,480.00			60.00		1,420.00
9	Credit Card	608.00			20.00		588.00
Lowest values (2)

Cell Formulas
Range	Formula
B7:B9	B7	=MINIFS(G$3:G6,A$3:A6,A7)
G3:G9	G3	=B3-E3

This specifically is what I ended up using:

=IF(A8="", "", MINIFS($G$3:G7,$A$3:A7,A8))

Are there any other formulas that show blank if A column is blank or is this pretty much it?

 

[Peter_SSs]

This specifically is what I ended up using:

=IF(A8="", "", MINIFS($G$3:G7,$A$3:A7,A8))

Are there any other formulas that show blank if A column is blank or is this pretty much it?

No, that looks exactly right to me.