Thread: Excel why cant A(row()) replace A1 or A2 to repet formula dn rows
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.newusers
Gary''s Student Gary''s Student is offline
external usenet poster
  
Posts: 11,058
Default Excel why cant A(row()) replace A1 or A2 to repet formula dn rows
=INDIRECT("A" & ROW(A1))
--
Gary''s Student - gsnu200909


"jimmy" wrote:

I want to copy formula down many rows but don't want to have to retype row
numbers at every different row
Reply With QuoteReply With Quote