Forum Discussion
Excel formula
Good evening all. I have a big spreadsheet where I need to perform a task I don't know how to do it: A 1 M 2 N For instance, I have the data shown above. Then I have this formul...
The formula in D1, copied across columns starting in E1, is:
=INDEX($A:$A,
COLUMN(A1))
=INDEX($A:$A,
COLUMN(A1))
Hi Twifoo.
I'm trying to test your formula, but I'm afraid the language of my Excell (portuguese) neither recognize the 'column' input nor has an equivalent input. Or I can not find it. I'm trying to solve this my new problem and then I'll come back to you.
Thank you
Carlos