Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Finding MAX number (excluding a particular number)
On 24 Apr 2005 04:06:53 -0700, "Johnny" wrote:
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. Use this **array** formula: =MAX(IF(D3:D7<125,D3:D7)) To enter an **array** formula, after typing it in, hold down <ctrl<shift while hitting <enter. Excel will place braces {...} around the formula. --ron |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Subtracting number of days excluding the weekend | Excel Discussion (Misc queries) | |||
finding last number in row excluding 0's | Excel Worksheet Functions | |||
lowest number in a set EXCLUDING zero | Excel Worksheet Functions | |||
finding a number and the number of times it occurs | Excel Discussion (Misc queries) | |||
Is there a way to get an average, excluding the lowest number? | Excel Discussion (Misc queries) |