Larry, THe simple solution seems to be putting the following formulas in a cell. =MAX(xx:yy) where xx and yy are cell range references. =MIN(xx:yy) gets you the same for MIN. Hope that helps Kevin