Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Locating the max value AND performing a fn on it only
I think this may be a toughy. I know the MAX function will identify the max
value in a range or whatever. I want to locate that Max and perform a function ONLY on the Max value. A hypothetical. Suppose that I want to subtract 50 from the item which is the MAX in a range: 100 150 200 I would like to return 100 150 150 But if it original date we 250 150 200 I would like to return 200 150 200. Is there any way to do this? Thanks, Pradhan |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
performing regression | New Users to Excel | |||
Performing calculations if a value is between A and B | Excel Worksheet Functions | |||
performing different calculatons on whether yes or no is selected | Excel Worksheet Functions | |||
performing least squares | Excel Discussion (Misc queries) | |||
Macros not performing correctly | Excel Discussion (Misc queries) |