Thread: Dynamically display in Active Cell value from 2 rows above it
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student Gary''s Student is offline
external usenet poster
  
Posts: 11,058
Default Dynamically display in Active Cell value from 2 rows above it
=INDIRECT(SUBSTITUTE((LEFT(ADDRESS(1,COLUMN()),3)) ,"$","") & ROW()-3)

--
Gary''s Student - gsnu200720
Reply With QuoteReply With Quote