Thread: =OFFSET(cell("address"),-1,0)
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Phillips
 
Posts: n/a
Default =OFFSET(cell("address"),-1,0)
why not just use

=OFFSET(H20,-1,0)

in H20

--

HTH

RP

"JJ" wrote in message
...
What is wrong with this? I want to be able to place this formula anywhere
in
a spreadsheet and have it return the cell above it. Thanks!

=OFFSET(cell("address"),-1,0)


Reply With QuoteReply With Quote