Display Values of Column/Range/Array/Other

[Laelsa]

haven't seen anyone ask or address this question. I want to automagically list the values/contents of a range, column or an array. And I do not want to manually do anything other than repopulate the contents of the range/column/array.

For example:

Column A has a row value in each cell from A1:A100. So each row is 1, 2, 3, 4,.... 99, 100.

I want Column B to list all the values of Column A without any touching of Column B.

If I add/change/remove any values of Column A, Column B is auto-updated.

So far, the best solution I have found, is to count the number of values in Column A and then past a range directly into Column B, not B1 but the Column B, "=A$1:A$XXXXXXX". Sadly this works but it also fills out the column to the maximum amount of rows allowed. This is what I am trying to avoid.

Thanks!

[sglife]

What do you want the column B to show out?
How is the change of B if A change?