ExcelBanter - conditional max

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - conditional max (https://www.excelbanter.com/excel-discussion-misc-queries/13888-conditional-max.html)

Brian Cornejo

conditional max

--
Brian

Max

conditional max

An example?

Supposing C1:C5 contains: 1,2,3,45,23

If you array-enter* in say, D1: =MAX(IF(C1:C5<10,C1:C5))
*press CTRL+SHIFT+ENTER (instead of just ENTER)

D1 will return 3, which is the max number of all numbers less than 10 within
the range C1:C5

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Brian Cornejo" wrote in message
...

--
Brian

All times are GMT +1. The time now is 05:01 PM.