Thread: Help with Address(), Indirect(), Offset
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
James Ravenswood James Ravenswood is offline
external usenet poster
  
Posts: 143
Default Help with Address(), Indirect(), Offset
Or another:

=INDIRECT(ADDRESS(ROW(INDIRECT(A1)),COLUMN(INDIREC T(A1))+1))
Reply With QuoteReply With Quote