Thread: Is there any funcion like a @maxif or @minif?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
TomPl TomPl is offline
external usenet poster
  
Posts: 342
Default Is there any funcion like a @maxif or @minif?
You could use an if statement like:

=IF(A1="Hello",MAX(B:B),"SkipIt")

Just Tom


Reply With QuoteReply With Quote