HELP creating formula

[Glennodx]

Hello,

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Column 1[/TD]
[TD]Column 2[/TD]
[TD]Column 3[/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD]1[/TD]
[TD]24[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]2[/TD]
[TD]22[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]2[/TD]
[TD]28[/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD]1[/TD]
[TD]21[/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD]2[/TD]
[TD]18[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]2[/TD]
[TD]32[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]1[/TD]
[TD]20[/TD]
[/TR]
</tbody>[/TABLE]

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.