Combining Multiple Lists?

[Liam19871]

Hello! For the life of me i just cant get this to work, annoying as it is! Ive looked for ages on the internet!


Theres the example, I want collumn E to add all the list together to make 1 containous on. If i add more to the list I want Collumn D to automatically add this together. Can only be formulas and no ribbons!

Thanks for any advice
Liam

[Pete_UK]

You can use this formula in E1:

=IF(ROWS($1:1)<=COUNTA(A:A),INDEX(A:A,ROWS($1:1)),IF(ROWS($1:1)<=COUNTA(A:B),INDEX(B:B,ROWS($1:1)-COUNTA(A:A)),IF(ROWS($1:1)<=COUNTA(A:C),INDEX(C:C,ROWS($1:1)-COUNTA(A:B)),"")))

then copy down as far as you need to. You can add extra items at the bottom of the lists in any order (hint: use a, b, c, d etc in column B to see the effect better).

Hope this helps.

Pete

[Liam19871]

Cheers, works perfect

[Pete_UK]

Glad to hear it.

If that takes care of your original question, please take a moment to select Thread Tools from the menu above and to the right of your first post in this thread, and mark the thread as SOLVED.

Also, since you are relatively new to the forum, you might like to know that you can directly thank those who have helped you by clicking on the small "star" icon located in the lower left corner of a post that you have found to be helpful (not just in this thread - for any post that has helped you). This also adds to the reputation of the poster (the small green bars in the poster's profile).

Pete