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 |
finding 1 formula result in a group of cells
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 |
finding 1 formula result in a group of cells
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 |
finding 1 formula result in a group of cells
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 --- |
finding 1 formula result in a group of cells
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 |
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 |
finding 1 formula result in a group of cells
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. |
All times are GMT +1. The time now is 08:06 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com