Min Value based on two conditions

[vranjit138]

Hi

I working on two sheets
sheet 1 has Name, area, Unit Price and amount ,
in the sheet 2 i have the customer ID .. i require the minimum unit price based on the name and area.


There are multiple prices for each name and each name repeats many times

How can this be done

Regards
Ranjit

 

[Krishnakumar]

Hi,

=MIN(IF(Sheet1!A2:A20=A2,IF(Sheet1!B2:B20=B2,Sheet1!C2:C20)))

where a2:a20 = NameRange

b2:b20 = AreaRange

c2:c20 = UnitPriceRange

Formula must be confirmed with Ctrl+Shift+Enter

HTH

 

[Domski]

Hi,

Not sure if I understand your problem completely but something like this might be what you're after:

Book1
	A	B	C	D
1	Name	Area	Price
2	NameA	Area1	132
3	NameB	Area1	132
4	NameC	Area1	147
5	NameA	Area1	173
6	NameB	Area1	172
7	NameC	Area1	112
8	NameA	Area2	148
9	NameB	Area2	177
10	NameC	Area2	176
11	NameA	Area2	155
12	NameB	Area2	134
13	NameC	Area2	154
14
15
16
17	NameA	Area1	132
Sheet1

Formula must be entered with Ctrl+Shift+Enter.

Dom

 

[vranjit138]

Hey Krishna,

that really works

great

Thanks