Max If function

B

BK

Ron,

The below formula works in case column A has text value. If my col A has numerical value , how can i write the formula to find max value in Col B ???


=MAX(INDEX((A2:A10="Dog")*B2:B10+(A2:A10<>"Dog")*MIN(B2:B10),0))


Thanks in advance

BK
 
S

ShaneDevenshire

Hi,

You question isn't clear to me but if you are trying to find the maximum
value in column b which for a given numerical value in column A then
=MAX(IF(A1:A10=1,B1:B10,""))

This should be array entered. Press Shift+Ctrl+Enter
 

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

match and display 5
Sumif with more than one criteria 15
Variable Sumproduct Range 6
Number of days in overlapping date ranges (using array formula?) 7
trying to set conditions for a range of cells 8
How to count unique values with multiple criteria 1
Invert a column 5
HYPERLINK() referring value from a cell does not change when cell 1

Top