If they are all numbers (no letters or other chars), try the MAX and
MIN functions.

http://office.microsoft.com/en-us/ex...625171033.aspx
http://office.microsoft.com/en-us/ex...625201033.aspx


--JP

On May 27, 8:28 pm, cjbarron5
wrote:
how do you find the smallest and largest number in a row of cells( part#s)