Minimum If...

[tarekabdullahm]

Dear all,

I have this data:


USD 200.00
EUR 100.00
USD 250.00
USD 300.00
EUR 500.00
USD 400.00
EUR 450.00
EUR 150.00
USD 350.00

I need to give the minimum amount in USD or EUR.

 

[Peter_SSs]

Formula in E2: =MIN(IF(A1:A9=E1,B1:B9))
which must be confirmed with Ctrl+Shift+Enter, not just Enter

Mr Excel.xls
	A	B	C	D	E	F
1	USD	200		Currency	EUR
2	EUR	100		Minimum	100
3	USD	250
4	USD	300
5	EUR	500
6	USD	400
7	EUR	450
8	EUR	150
9	USD	350
10
Minimum