View Single Post
  #1   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

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