Help with finding largest value

P

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
 
R

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
Click to expand...

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
 
Top