• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Adding indirect function to the whole column at once

A

akuku

New Member
Hi All!


I have quick question. In one column we have cells in which are functions as follows:

=C1

=C2

=C3

=C4

...

=C1000


So one column with cells showing values from other cells. How we can add to all those cells indirect function to get:

=indirect("C1")

=indirect("C2")

=indirect("C3")

...

=indirect("C1000")


I don't want to edit every single cell to input indirect function but would like to do it faster. Do you know any solution?


Thanks in advance!
 
akuku - first a warning about Indirect - it might cause you performance issues if your spreadsheet is large. A better alternative will likely be INDEX. See http://chandoo.org/forums/topic/what-is-indirect-function


Secondly, you just go something like this:

=INDIRECT("C"&ROW() )


But again, I'd recommend INDEX. Can you post a link to a sample spreadsheet, so I can implement this for you?
 
You must log in or register to reply here.
Back
Top