ExcelBanter - Number of columns ?

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Number of columns ? (https://www.excelbanter.com/excel-worksheet-functions/17852-number-columns.html)

Toosje

Number of columns ?

I am using

=COLUMN(C:C)-COLUMN(A:A)+1

to calculate the number of the columns A to C (=3).
How can I use replace the C's and A's in the formula, referring to
cell-adresses?

The following formula does not result in 3.

=COLUMN(LEFT(C1,1):LEFT(C1,1))-COLUMN(LEFT(A1,1):LEFT(A1,1))+1

where contents cell C1 = C10 and cell A1 = A10 for example.

Who can help me on this?

Arvi Laanemets

Hi

=COLUMN(INDIRECT(C1))-COLUMN(INDIRECT(A1))+1

--
When sending mail, use address arvil<attarkon.ee
Arvi Laanemets

"Toosje" wrote in message
...
I am using

=COLUMN(C:C)-COLUMN(A:A)+1

to calculate the number of the columns A to C (=3).
How can I use replace the C's and A's in the formula, referring to
cell-adresses?

The following formula does not result in 3.

=COLUMN(LEFT(C1,1):LEFT(C1,1))-COLUMN(LEFT(A1,1):LEFT(A1,1))+1

where contents cell C1 = C10 and cell A1 = A10 for example.

Who can help me on this?

Toosje

Thanks Arvi, that's the solution!

Toosje

"Arvi Laanemets" schreef:

Hi

=COLUMN(INDIRECT(C1))-COLUMN(INDIRECT(A1))+1

--
When sending mail, use address arvil<attarkon.ee
Arvi Laanemets

"Toosje" wrote in message
...
I am using

=COLUMN(C:C)-COLUMN(A:A)+1

to calculate the number of the columns A to C (=3).
How can I use replace the C's and A's in the formula, referring to
cell-adresses?

The following formula does not result in 3.

=COLUMN(LEFT(C1,1):LEFT(C1,1))-COLUMN(LEFT(A1,1):LEFT(A1,1))+1

where contents cell C1 = C10 and cell A1 = A10 for example.

Who can help me on this?

All times are GMT +1. The time now is 07:36 PM.