Thread: MAX IF? - Return MAX if Condition met in Separate Column
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
wx4usa wx4usa is offline
external usenet poster
  
Posts: 122
Default MAX IF? - Return MAX if Condition met in Separate Column
I need a formula that will return the MAX value in Column A if these
column A numbers have "Active" in column B.

Column B is either Active or Inactive. Column A is age in days from
1-534.

Is there such a thing as MAX IF?

Reply With QuoteReply With Quote