Is it possible to use column number in a formula?

[motilulla]

Hello,</SPAN></SPAN>

In the example below I got formula in cell J3 copied to down J32 "=COUNTIF($D$3:$D$37,I3)" which is counting column D numbers, to count column E numbers i need to change the formula to this "=COUNTIF($E$3:$E$37,I3)".</SPAN></SPAN>

Is it possible instead of changing the column letter in the formula if I type in cell G3 = 4 so it count column 4 which is D, and if I type in cell G3 = 5 so it count column 5 which is E </SPAN></SPAN>

Resume: change the formula column letter as per column number assigned in G3</SPAN></SPAN>

Example...</SPAN></SPAN>

Book1
	A	B	C	D	E	F	G	H	I	J
1
2				n1	n2				Unique Num	Count D
3				16	29		4		1	4
4				7	13				2	3
5				14	18				3	2
6				4	7				4	3
7				15	24				5	3
8				25	30				6	3
9				3	4				7	2
10				4	12				8	1
11				1	4				9	2
12				14	15				10	0
13				6	10				11	0
14				5	6				12	1
15				15	16				13	0
16				1	3				14	2
17				15	29				15	4
18				6	11				16	1
19				9	13				17	0
20				2	7				18	0
21				2	23				19	0
22				3	21				20	1
23				4	23				21	1
24				2	5				22	0
25				24	26				23	0
26				7	10				24	1
27				9	10				25	1
28				5	15				26	0
29				20	27				27	0
30				6	9				28	0
31				1	11				29	0
32				8	12				30	0
33				5	25
34				15	18
35				21	26
36				12	20
37				1	10
Sheet1

Cell Formulas
Range	Formula
J3	=COUNTIF($D$3:$D$37,I3)
J4	=COUNTIF($D$3:$D$37,I4)
J5	=COUNTIF($D$3:$D$37,I5)

Thank you all</SPAN></SPAN>

Excel 2000</SPAN></SPAN>
Regards,</SPAN></SPAN>
Moti</SPAN></SPAN>

 

[Fluff]

How about
=COUNTIF(INDEX($A$3:$E$37,0,G$3),I3)

 

[motilulla]

How about
=COUNTIF(INDEX($A$3:$E$37,0,G$3),I3)

Fluff, yes your formula is doing the job perfect!!

Thank you for your help. Have a nice weekend </SPAN></SPAN>

Kind Regards</SPAN></SPAN>
Moti </SPAN></SPAN>

 

[James006]

Hello,

If you are using : $D$3:$E$37

In order to still get your results ...

the value of cell G3 must be changed from 4 to 1

Hope this will help

 

[Fluff]

Fluff, yes your formula is doing the job perfect!!

Thank you for your help. Have a nice weekend

Kind Regards
Moti

You're welcome & thanks for the feedback

 

[motilulla]

Hello,

If you are using : $D$3:$E$37

In order to still get your results ...

the value of cell G3 must be changed from 4 to 1

Hope this will help

James006, yes I did question to Fluff but as I noticed myself I edit the post#3, as you read it quick, and you replied my question. Thank you for the remake and reply.</SPAN></SPAN>

Have a nice weekend</SPAN></SPAN>

Kind Regards</SPAN></SPAN>
Moti </SPAN></SPAN>