I may be missing something, but don't you just want the max function?
=max(a1:a10)

--
Kevin Vaughn


"SB" wrote:

Hello I need to create a conditional formula that will select ONLY the cell
with the greatest value. So... I have a series of cells with values and I
want to populate another cell using a formula that will be the greatest value
only.

CAN you please help..... Thank you