Columns Function

[ViKaMi]

I'm trying to use the Columns function. For array I'm using range name. If I put the range name directly on the formula it gives me the desired result. I want the formula to read the range name from a cell. Where I can type different range names instead of changing the range name (array) directly inside the formula.

range contains 7 rows and 22 columns.

range name = P2_

formula - =columns(P2_) returns 22 which is the desired result

formula =columns(C3) where C3 have P2_ typed in returns a result of 1

 

[awoohaw]

I think you need to use the indirect function:

=Columns(Indirect(C3))

 

[awoohaw]

Mr Excel 8.xlsm
	A	B	C	D	E
1
2	P2_		3	2	4
3			3	2	8
4	1		4	6	8
5			9	9	10
6	3		7	4	9
7			6	8	7
8			1	7	8
9			8	9	6
10			3	9	1
11			9	7	8
Sheet15

Cell Formulas
Range	Formula
A4	A4	=COLUMNS(A2)
A6	A6	=COLUMNS(INDIRECT(A2))

 

[ViKaMi]

I think you need to use the indirect function:

=Columns(Indirect(C3))

Worked, thanks

 

[awoohaw]

Worked, thanks

Happy to help!