Number of columns ?

T

Toosje

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using the AND and OR functions in the same formula 6
Using the LEFT formula for multiple cells 2
Continued.....answer 8 - 1.2 = 6.2 from a formula 0
can I get some help here? No response yet :) 5
Left Function Question Help! 3
COUNTIFS ? 1
In Cell Formula to mimic text to columns. 4
Row reference for consecutive series calculation 0

Top