finding 1 formula result in a group of cells

[Richdg]

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

 

[Max]

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!A1: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

 

[AltaEgo]

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

 

[Max]

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
---

 

[AltaEgo]

Provided the number is positive.
Otherwise

=Sum(YourTenCellsAddressRange)

 

[Richdg]

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

Thanks for your input steve

 

[Max]

Welcome
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:25,000 Files:300 Subscribers:70
xdemechanik