ExcelBanter - formula

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

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

- - formula (https://www.excelbanter.com/excel-discussion-misc-queries/34260-formula.html)

tigerpaw52283

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.

Barb R.

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.

All times are GMT +1. The time now is 03:59 PM.