H
hdf
I have a table with two rows, 33 columns long. Top row has Years (200
to 2036) in it and the row below is intended for the inputing of value
in percentage form. Some of the cells in bottom row may be left blan
or with 0 value.
Elsewhere on my spreadsheet I want to create formulas that will retur
the top row value (year) for each year where the value in bottom row i
greater than 0.
For example, if
A1 = 2004 A2 = 2005 A3 = 2006 A4 = 2007
B1 = 0 % B2 = 5 % B3 = blank B4 = 20%
What formula in cell C1 will return value "2005" and in cell C2 th
next year value for which the cell in row B is not blank or 0, hence i
this case "2007".
Thank you,
Hecto
to 2036) in it and the row below is intended for the inputing of value
in percentage form. Some of the cells in bottom row may be left blan
or with 0 value.
Elsewhere on my spreadsheet I want to create formulas that will retur
the top row value (year) for each year where the value in bottom row i
greater than 0.
For example, if
A1 = 2004 A2 = 2005 A3 = 2006 A4 = 2007
B1 = 0 % B2 = 5 % B3 = blank B4 = 20%
What formula in cell C1 will return value "2005" and in cell C2 th
next year value for which the cell in row B is not blank or 0, hence i
this case "2007".
Thank you,
Hecto