Dynamic Column

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I am trying to count the cells in a column. The column is dynamic, ie. it changes according to input for elsewhere. I have tried to use the Indirect function, but I cant get it right.

The function i will use it in is below, where x is the column that is dynamic.
=Counta($x:$x)
 
Hi
if cell A1 stores the column character try
=COUNTA(INDIRECT(A1 & ":" & A1))
-----Original Message-----
Hi,

I am trying to count the cells in a column. The column is
Click to expand...
dynamic, ie. it changes according to input for elsewhere.
I have tried to use the Indirect function, but I cant get
it right.
 
Hi
then use:
=COUNTA(INDIRECT("C" & A1,FALSE))
-----Original Message-----
Frank,

I do not have the column character. I only have the Column number.
--
Peter B
Norway



.
Click to expand...
 
Back
Top