View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Claus Busch Claus Busch is offline
external usenet poster
 
Posts: 3,872
Default copying down while changing columns

Hi Jan,

Am Wed, 20 Feb 2019 04:57:16 -0800 (PST) schrieb Daddy Sage:

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.


for column B try:
=COUNTA(OFFSET($B$1,,ROW(A1)-1,1000))
ans copy down.


Regards
Claus B.
--
Windows10
Office 2016