If the other cells results are blank, you might try
=Max(YourTenCellsAddressRange)

--
Steve

"Richdg" wrote in message
...
I have ten cells in a row that have a formula in each. Only one of the
cells
will display a result at any one time but it changes depending on the
date. I
need a formula that will find the cell displaying the result and display
it
in a single cell in another worksheet