Excel List [Closed]

Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hello,

If i have a list of one thing in column A and list of another in column B, Can i get a full list of any column in another sheet with some formula?

3 replies

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
767
Not clear what you are asking

you can use some thing like this

=sheet1!A1 to show a1 from sheet1 on some other sheet
Can i get a whole column just by one formula
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
767
I still am not sure what is meant by "getting whole column".

Lets say if col A consist of 10 rows of data, and you are thinking that on sheet2, you will write a formula on cell A1 and as the result of that formula, on sheet2, rows 1-10 will get populated, from top of my head, I dont see how can you do that.

If you are thinking to have on cell a1, a concatenated list from sheet1, then you would have to write a user defined function.

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!