Thread: finding 1 formula result in a group of cells
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.newusers
Richdg Richdg is offline
external usenet poster
  
Posts: 4
Default finding 1 formula result in a group of cells
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
Reply With QuoteReply With Quote