| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Array formula SUMIF with 2D sum_range array | Excel Worksheet Functions | |||
| Array formula: how to join 2 ranges together to form one array? | Excel Worksheet Functions | |||
| Find specific value in array of array formula | Excel Worksheet Functions | |||
| Array Formula - using LEFT("text",4) in formula | Excel Worksheet Functions | |||
| Convert Normal formula to array formula | Excel Programming | |||
![Steph[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
