Reference column by number

L

Legacy 5596

Guest
Ok, imagine Excel didn't have column letters, and you simply had x,y
x= column, y=row.
Now, I know the column I want is column 7 (which is column G)and that I want the data from rows 3 thru 62.
Normally I could do G3:G62
But using the premise that I only know the number of the column, how can I do the same thing as G3:G62?
 

Excel Facts

Using Function Arguments with nested formulas
If writing INDEX in Func. Arguments, type MATCH(. Use the mouse to click inside MATCH in the formula bar. Dialog switches to MATCH.
Yea it functions great, pulling call center data:
BREAKDOWN
The result is to know how many CSRs needed at any given hour based on accepted abandon rate of calls, figuring in how many calls are expected that given hour. I roundup so that the numbers match data being precisely accessed in the other sheets.

P.S. -- Barry -- Your code would have worked if I'd used the option from the beginning. It was just too difficult for me to think in r1c1 mode. But thanks!
 
Upvote 0

Forum statistics

Threads
1,213,543
Messages
6,114,238
Members
448,555
Latest member
RobertJones1986

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top