| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Finding the Largest Number, based on two criteria
Hi there,
Hopefully someone can help, I need to find the largest number in a column. i.e column A has region names North, South, East and West all the way down to row 100 column B has numbers all the way down to row 100 what I am wanting is a formula that can tell me the highest number North, South, East and West have in column B tia BigH |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Finding the Largest Number, based on two criteria
=MAX(IF(A1:A100="West",B1:B100)
etc. which is an array formula, it should be committed with Ctrl-Shift-Enter, not just Enter. -- HTH Bob Phillips (remove nothere from email address if mailing direct) "BigH" wrote in message ... Hi there, Hopefully someone can help, I need to find the largest number in a column. i.e column A has region names North, South, East and West all the way down to row 100 column B has numbers all the way down to row 100 what I am wanting is a formula that can tell me the highest number North, South, East and West have in column B tia BigH |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
| Returning Results Based on Two Criteria | Excel Worksheet Functions | |||
| Counting the number of cells meeting conditional formating criteria | Excel Worksheet Functions | |||
| Finding the 3rd largest number in a list | Excel Worksheet Functions | |||
| Subtracting based on number of miles | Excel Discussion (Misc queries) | |||
Linear Mode
