Finding the Largest Number, based on two criteria

B

BigH

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
 
B

Bob Phillips

=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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Count Numbers 12
Lookup by row and column 2
Count unique values based on multiple criteria 2
Copying data from one workbook to another dependent on user select 1
Can I choose more than one item in the page field area? 1
Count Numbers 4
Formula Problem which includes Sum,If,Frequency,match and row 2
vlookup with 2 sets of criteria 2

Top