Thread: copying down while changing columns
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Daddy Sage Daddy Sage is offline
external usenet poster
  
Posts: 24
Default copying down while changing columns
In one cell I have the following formula: =COUNTA(B2:B1000). Copying down I like ti to change the column to

=COUNTA(C2:C1000)
=COUNTA(D2:D1000) and so on.

I have tried OFFSET and TRANSPOSE but can't get it to work.

Any ideaes?

Jan
Reply With QuoteReply With Quote