=max(1:1)
or
=large(1:1,1)

=large(1:1,2)
and
=large(1:1,3)

1:1 is the address of row 1 (all the cells in that row). You could use A1:X1 if
you wanted.



DHSBob wrote:

I am trying to come up with a formula(s) that will give me the top 3 values
in a series of numbers that are in a row. These 3 values will each be in a
separate cell.

--

Dave Peterson