Home |
Search |
Today's Posts |
#1
|
|||
|
|||
formula
i am working on a spread sheet that contains a lot of values. is there a
formula that i can input into a cell that would have excel either go across a row and find the highest value and put it in that cell or the lowest value and put it into a cell. |
#2
|
|||
|
|||
Won't MIN or MAX do it?
"tigerpaw52283" wrote: i am working on a spread sheet that contains a lot of values. is there a formula that i can input into a cell that would have excel either go across a row and find the highest value and put it in that cell or the lowest value and put it into a cell. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
referencing named formula using INDIRECT function | Excel Worksheet Functions | |||
Simplify formula | Excel Worksheet Functions | |||
put formula results into a different cell if it is empty | Excel Worksheet Functions | |||
how do i write a formula and keep in in formula form, so it DOESN. | Excel Discussion (Misc queries) | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) |