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

Assume the 10 cells are in A1:J1 in Sheet1
In another sheet,
you could use this, normal ENTER:
=INDEX(Sheet1!A1:J1,MATCH(TRUE,INDEX(TRIM(Sheet1!A 1:J1)<"",),0))

Success? Savour it, click the YES button below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:25,000 Files:300 Subscribers:70
xdemechanik
---
"Richdg" wrote:
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

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

The earlier expression is generic. It will work regardless whether the result
to be returned from that group of ten cells is numeric or text.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:25,000 Files:300 Subscribers:70
xdemechanik
---

Provided the number is positive.
Otherwise

=Sum(YourTenCellsAddressRange)

--
Steve

"AltaEgo" <Somewhere@NotHere wrote in message
...
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

that work perfectly max ill be able to sleep at night now thanks heaps.

Thanks for your input steve

"Max" wrote:

Assume the 10 cells are in A1:J1 in Sheet1
In another sheet,
you could use this, normal ENTER:
=INDEX(Sheet1!A1:J1,MATCH(TRUE,INDEX(TRIM(Sheet1!A 1:J1)<"",),0))

Success? Savour it, click the YES button below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:25,000 Files:300 Subscribers:70
xdemechanik
---
"Richdg" wrote:
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

Welcome
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:25,000 Files:300 Subscribers:70
xdemechanik
---
"Richdg" wrote in message
...
that work perfectly max ill be able to sleep at night now thanks heaps.