how do you find the smallest and largest number in a row of cells( part#s)

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)

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)

--
Array formulas must be entered with CSE, <Ctrl <Shift <Enter, instead of
the regular <Enter, which will *automatically* enclose the formula in curly
brackets, which *cannot* be done manually. Also, you must use CSE when
revising the formula.

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"cjbarron5" wrote in message
...
how do you find the smallest and largest number in a row of cells( part#s)