how do you find the smallest and largest number in a row of cells( part#s)
C cjbarron5 May 28, 2008 #1 how do you find the smallest and largest number in a row of cells( part#s)
J JP May 28, 2008 #2 If they are all numbers (no letters or other chars), try the MAX and MIN functions. http://office.microsoft.com/en-us/excel/HP100625171033.aspx http://office.microsoft.com/en-us/excel/HP100625201033.aspx --JP
If they are all numbers (no letters or other chars), try the MAX and MIN functions. http://office.microsoft.com/en-us/excel/HP100625171033.aspx http://office.microsoft.com/en-us/excel/HP100625201033.aspx --JP
R RagDyer May 28, 2008 #3 If they're *real* numbers: =Max(A1:Z1) =Min(A1:Z1) If they're Text, you might try these*array* formulas: =Max(--A1:Z1) =Min(--A1:Z1)
If they're *real* numbers: =Max(A1:Z1) =Min(A1:Z1) If they're Text, you might try these*array* formulas: =Max(--A1:Z1) =Min(--A1:Z1)
