On one sheet I have a monthly column of numbers where only the end of
the year is populated (for 50 years), as an example
A B
7/31/2007 0
8/31/2007 0
9/30/2007 0
10/31/2007 0
11/30/2007 0
12/31/2007 123.456
.
.
.
What I would like to do is to create another column that has 1 year for
each row:
X Y
12/31/2007 123.456 (=A6)
12/31/2008 456.678 (=A(6+12))I'm not sure how to set up a formula is column Y that will reference the end of year numbers. -- -- Jerry Feldman <[EMAIL PROTECTED]> Boston Linux and Unix PGP key id: 537C5846 PGP Key fingerprint: 3D1B 8377 A3C0 A5F2 ECBB CA3B 4607 4319 537C 5846
signature.asc
Description: PGP signature
