HELP creating formula

[Glennodx]

Hello,

Column 1	Column 2	Column 3
B	1	24
A	2	22
A	2	28
C	1	21
B	2	18
A	2	32
A	1	20

<tbody>
</tbody>

Say if I have 3 columns as above, I want to get the minimum value of column 3 among the matching sets in column 1 AND 2 only. i.e. result should only get 22 (min. of A-2)

Any hlp would be much appreciated.

 

[Aladin Akyurek]

Is this what you are after?

Control+shift+enter, not just enter:

=MIN(IF(FREQUENCY(IF(1-(A1:A7=""),IF(1-(B1:B7=""),MATCH(A1:A7&B1:B7,A1:A7&B1:B7,0))),ROW(C1:C7)-ROW(C1)+1)>1,C1:C7))

 

[kvsrinivasamurthy]

Try this.
ARRAY formula in D2, then drag down

=SMALL(IF(($A$2:$A$8=A2)*($B$2:$B$8=B2),$C$2:$C$8,""),1)

To enter ARRAY formula
Paste the formula
Press F2
Press Ctrl+Shift+Enter keys together.
formula will be covered with{} brackets by excel.