Help with finding largest value
 

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


--
paula

Is it not just...

=MAX(Range)

for max and

=MIN(Range)

for min?

paula wrote:
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

On Sun, 6 Feb 2005 16:17:44 +0000, paula
wrote:


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$10 0),"min",""))

and copy/drag down to B100


--ron