C
Creator
--
Creator
Creator
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
C
Creator
Why does this formula give me an error?
=offset(ADDRESS(ROW(),COLUMN()),1,1,1,1)
=offset(ADDRESS(ROW(),COLUMN()),1,1,1,1)
B
bj
what is the error?
if the equation were in cell A1, it should give the value in B2
what does it do?
if the equation were in cell A1, it should give the value in B2
what does it do?
C
Creator
The formula you typed contains an error.........no specifics
C
Creator
Hey bj, thanks....it worked!!
--
Creator
--
Creator
bj said:the address function gives a text response not a referense response
try
=OFFSET(INDIRECT(ADDRESS(ROW(),COLUMN())),1,1,1,1)
B
bj
the address function gives a text response not a referense response
try
=OFFSET(INDIRECT(ADDRESS(ROW(),COLUMN())),1,1,1,1)
try
=OFFSET(INDIRECT(ADDRESS(ROW(),COLUMN())),1,1,1,1)