H
Hfreeman
I've been trying to find a way to do this and it is driving me crazy.
Is there away (without going into programming mode, just with functions) to
reference a cell by saying <usethe integer result returned by this formula
as the row number><the column number returned by this formula as the cloumn
number> ????
I don't think this is possible with either INDIRECT or LOOKUP
The specific problem is a workbook with two sheets, DAYS and WEEKS. DAYS
has 356 rows, one per day of the year, with some data. WEEKS has 52 rows,
with calculated weekly data. In a certain column on WEEKS, in each row, I
want to reference the value in a column on DAYS from every 7th row.
This would be so easy if on the weeks sheet I could just write in cell A1 of
WEEKS something like
=DAYS!A[7*ROW()] (or some such syntax)
meaning "return the value of the cell in DAYS whose column value is "A" and
whose
row number is found by taking row number of the cell this formula (on WEEKS)
and multiplying it my 7.
If I put this formula A1 of WEEKS and copied it to all the other rows, I
would then have a colum of 52 values in column A of WEEKS equal to the values
in every 7th cell in column A of DAYS.
Is there away (without going into programming mode, just with functions) to
reference a cell by saying <usethe integer result returned by this formula
as the row number><the column number returned by this formula as the cloumn
number> ????
I don't think this is possible with either INDIRECT or LOOKUP
The specific problem is a workbook with two sheets, DAYS and WEEKS. DAYS
has 356 rows, one per day of the year, with some data. WEEKS has 52 rows,
with calculated weekly data. In a certain column on WEEKS, in each row, I
want to reference the value in a column on DAYS from every 7th row.
This would be so easy if on the weeks sheet I could just write in cell A1 of
WEEKS something like
=DAYS!A[7*ROW()] (or some such syntax)
meaning "return the value of the cell in DAYS whose column value is "A" and
whose
row number is found by taking row number of the cell this formula (on WEEKS)
and multiplying it my 7.
If I put this formula A1 of WEEKS and copied it to all the other rows, I
would then have a colum of 52 values in column A of WEEKS equal to the values
in every 7th cell in column A of DAYS.