Help with finding largest value

[paula]

I have a data set and need to find the largest and smallest value, and
place max/min beside those values in the adjacent column. These values
need to be able to change if the values in the data set change. I
thought to use the if function and nest the large and small function
within it, but it does not seem to be working. Please help

 

[Aladin Akyurek]

Is it not just...

=MAX(Range)

for max and

=MIN(Range)

for min?

 

[Ron Rosenfeld]

I have a data set and need to find the largest and smallest value, and
place max/min beside those values in the adjacent column. These values
need to be able to change if the values in the data set change. I
thought to use the if function and nest the large and small function
within it, but it does not seem to be working. Please help

If your data set is in A1:a100, in B1 enter the formula:

=IF(A1=MAX($A$1:$A$100),"max",IF(A1=MIN($A$1:$A$100),"min",""))

and copy/drag down to B100


--ron