Array max formula?
 

Hello everyone. Was hoping for some formula help. With this abridged
sample data:

A 8
B 4
C 9
A 6
D 7
S 1
A 6

I conceptually would like excel to scan the first column (A), and identify
all A's, and return the Max of the value found in column B.

Array max formula?
 

Use the following array formula:

=MAX((A1:A10="A")*B1:B10)

Since this is an array formula, you must press Ctrl+Shift+Enter
rather than just Enter when you first enter the formula and
whenever you edit the formula later. If you do this correctly,
Excel will display the formula enclosed in curly braces {}.


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





"Steph" wrote in message
...
Hello everyone. Was hoping for some formula help. With this
abridged
sample data:

A 8
B 4
C 9
A 6
D 7
S 1
A 6

I conceptually would like excel to scan the first column (A),
and identify
all A's, and return the Max of the value found in column B.

Array max formula?
 

Thanks Chip!!

"Chip Pearson" wrote in message
...
Use the following array formula:

=MAX((A1:A10="A")*B1:B10)

Since this is an array formula, you must press Ctrl+Shift+Enter
rather than just Enter when you first enter the formula and
whenever you edit the formula later. If you do this correctly,
Excel will display the formula enclosed in curly braces {}.


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





"Steph" wrote in message
...
Hello everyone. Was hoping for some formula help. With this
abridged
sample data:

A 8
B 4
C 9
A 6
D 7
S 1
A 6

I conceptually would like excel to scan the first column (A),
and identify
all A's, and return the Max of the value found in column B.