Conditional Max value
 

Hi,

i have 2 columns and i'm trying to calculate the conditonal maximum from
column one.

These are the columns :

47 7
44 7
71 7
58 7
214 4
22 4
54 7
1 7
45 7
21 7


and i try to find a formula that gives the maximum in column one, where
column 2 has value 7

in this case this would be 58

Marc

Conditional Max value
 

Marc,

Use the following array formula:

=MAX(IF(B1:B10=7,A1:A10,FALSE))

Change the range references to match your data.

This is an array formula, so you must press CTRL+SHIFT+ENTER rather than
just ENTER when you first enter the formula and whenever you edit it later.
If you do this properly, Excel will display the formula enclosed in curly
braces {}.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
www.cpearson.com





"Marc" wrote in message
e...
Hi,

i have 2 columns and i'm trying to calculate the conditonal maximum from
column one.

These are the columns :

47 7
44 7
71 7
58 7
214 4
22 4
54 7
1 7
45 7
21 7


and i try to find a formula that gives the maximum in column one, where
column 2 has value 7

in this case this would be 58

Marc

Conditional Max value
 

Woehoe, works like spagetti with an Italian.

Thanks !
Marc

"Chip Pearson" wrote in message
...
Marc,

Use the following array formula:

=MAX(IF(B1:B10=7,A1:A10,FALSE))

Change the range references to match your data.

This is an array formula, so you must press CTRL+SHIFT+ENTER rather than
just ENTER when you first enter the formula and whenever you edit it
later.
If you do this properly, Excel will display the formula enclosed in curly
braces {}.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
www.cpearson.com





"Marc" wrote in message
e...
Hi,

i have 2 columns and i'm trying to calculate the conditonal maximum from
column one.

These are the columns :

47 7
44 7
71 7
58 7
214 4
22 4
54 7
1 7
45 7
21 7


and i try to find a formula that gives the maximum in column one, where
column 2 has value 7

in this case this would be 58

Marc