Posted to microsoft.public.excel.programming

Johnny[_9_] Johnny[_9_] is offline

external usenet poster

Posts: 8

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 Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Subtracting number of days excluding the weekend	The Rook[_2_]	Excel Discussion (Misc queries)	2	February 17th 09 09:15 AM
finding last number in row excluding 0's	Joe	Excel Worksheet Functions	8	August 20th 08 03:21 AM
lowest number in a set EXCLUDING zero	Bad Kitty	Excel Worksheet Functions	2	November 3rd 06 10:34 PM
finding a number and the number of times it occurs	luposlipophobia	Excel Discussion (Misc queries)	3	June 22nd 06 03:51 AM
Is there a way to get an average, excluding the lowest number?	TNTraining	Excel Discussion (Misc queries)	7	June 2nd 05 10:12 PM

All times are GMT +1. The time now is 07:00 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us