Problem with searching funtion

[Wiecman]

hi i've got problem with the searching function

I have three column . For example :


1 2 3

A K1w K12w 8

B K1p K2w 9

C K1w P1ab 10

D K1w K12w1 7


i want to find in kolumn 3 maximum value using funtion which will be search using 2 criterias : For example :

im seeking maximum value from komuln 3 only if (for example ) K1w from first komumn = K12w from second komuln .A result i want to have in one cell . How can i do that ?. thantk for help

[Cheeky Charlie]

Best way is a pivot table, but in one cell try:
=MAX(($A$1:$A$4="K1w")*($B$1:$B$4="K12w")*C1:C4)
entered with ctrl+shift+enter

HTH

[arthurbr]

Hi and welcome to the board
what are K1w and K12w ? Values or text strings ?
Maybe adding a sample wbook with the result you need might help