Thread: Looking for the equivalent of a Maxif function
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
JE McGimpsey JE McGimpsey is offline
external usenet poster
  
Posts: 4,624
Default Looking for the equivalent of a Maxif function
Oops, should have been

=MAX(IF(A1:A1000="Region 1",B1:B1000))

In article ,
JE McGimpsey wrote:

=MAX(IF(A1:A1000="Region 1"),A1:A1000))
Reply With QuoteReply With Quote