named range row offset
Hi!
Try this:
=INDEX(MyRow,COLUMN()-1)
If you put this formula in column A it obviously can't refer to a column to
the left of column A so the value in column A will be returned.
Biff
wrote in message
ups.com...
I recently discovered naming entire rows -- it makes references super
easy (when your columns line-up). For example, if I name row 2
"MyRow", then in other cells I could just put "=MyRow" and it will
reference the cell in MyRow (row 2) that is in the same column where I
put the formula.
For example, if I put "=MyRow" in cell C6 it returns C2, in D6 it
returns D2, E6 -- E2, you get the idea.
My question is whether there is an easy way to offset this by one
column (so that putting "=MyRow" in cell C6 returns B2 instead of C2).
Something like "=MyRow[-1]" would be great. Any ideas? Thanks.
|