Thread: Finding MAX number (excluding a particular number)
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Johnny[_9_] Johnny[_9_] is offline
external usenet poster
  
Posts: 8
Default Finding MAX number (excluding a particular number)
I did a search for help on this, but didn't find anything.
Using MAX to find the largest number in a column: =MAX(D3:D7)

If one of those numbers = 125, then I would like to exclude it from the
calculation. I've tried using DMAX, and IFs, but I can't get it to
work.

Reply With QuoteReply With Quote