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
|