Thread: =max(if(a2:a101=5.4,b2:b101))?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
coa01gsb
 
Posts: n/a
Default =max(if(a2:a101=5.4,b2:b101))?

Hi People,

I have two columns of data, I want to find the maximum value in column
B of rows whose corresponding row cell in column A contains 5.4. The
formula I have tried to use is:

=MAX(IF(A2:A101=5.4,B2:B101))

But this doesn't work. Any other ideas?

Can I define a name that will relate to all cells in column B whose
corresponding row cell in column A has a value of 5.4?


--
coa01gsb
------------------------------------------------------------------------
coa01gsb's Profile: http://www.excelforum.com/member.php...o&userid=31214
View this thread: http://www.excelforum.com/showthread...hreadid=521059

Reply With QuoteReply With Quote