How can you tell what a column number as referenced by the column alpha identifiers. Ex: Column AN would equal what column no?
How can you tell what a column number as referenced by the column alpha identifiers. Ex: Column AN would equal what column no?
=column(an1) gives the column number
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
In 2007 you can select Options >> Formulas >> and click on R1C1 reference style and it will change the columns from A, B, C etc to 1, 2, 3 etc.
BTW, Martin's rec is pretty cool too & easier, didn't know that one.
Last edited by Sam Capricci; 08-29-2013 at 02:29 PM.
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks