| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
conditional max
-- Brian |
|
#2
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Effect of Conditional Formatting, Data Validation | Excel Discussion (Misc queries) | |||
| conditional formatting conflict? | Excel Worksheet Functions | |||
| Determine cells that drive conditional formatting? | Excel Discussion (Misc queries) | |||
| Conditional formatting not available in Excel | Excel Discussion (Misc queries) | |||
| copy conditional format as ACTUAL format | Excel Discussion (Misc queries) | |||
Linear Mode
