| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Finding Maximum value while excluding some values
Hi I have a row of data with the cells I want to find a MAX for are separated from each other: a1=300 d1=500 g1=800 j1=10,000 I want to find the MAX value for a1,d1,g1,j1, but exclude and value over 1000. So instead of =MAX(a1,d1,g1,j1) returning 10,000, =???(???) will return the next highest max of 800. Thanks tx -- tx12345 ------------------------------------------------------------------------ tx12345's Profile: http://www.excelforum.com/member.php...o&userid=24776 View this thread: http://www.excelforum.com/showthread...hreadid=507940 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I use countif to count values excluding blank cells | Excel Worksheet Functions | |||
| Tricky 'Find Maximum' problem seeks formula | Excel Worksheet Functions | |||
| Finding (Multiple) Highest Values in Column | Excel Worksheet Functions | |||
| Finding number of values in a range on a per year basis | Excel Worksheet Functions | |||
| finding the coordinates of the maximum point on a graph | Charts and Charting in Excel | |||
Threaded Mode
