Minimum If...

tarekabdullahm

New Member
Joined
Mar 15, 2006
Messages
40
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.
 

Some videos you may like

Excel Facts

Square and cube roots
The =SQRT(25) is a square root. For a cube root, use =125^(1/3). For a fourth root, use =625^(1/4).

Peter_SSs

MrExcel MVP, Moderator
Joined
May 28, 2005
Messages
46,822
Office Version
  1. 365
Platform
  1. Windows
Formula in E2: =MIN(IF(A1:A9=E1,B1:B9))
which must be confirmed with Ctrl+Shift+Enter, not just Enter
Mr Excel.xls
ABCDEF
1USD200CurrencyEUR
2EUR100Minimum100
3USD250
4USD300
5EUR500
6USD400
7EUR450
8EUR150
9USD350
10
Minimum
 

Watch MrExcel Video

Forum statistics

Threads
1,113,849
Messages
5,544,645
Members
410,627
Latest member
georgealice
Top