How to populate a column in a sheet based on a column from another?

Beginner here.

I want to populate a column with the names of people in a new sheet, with the data to be taken from a column in an existing sheet. In this sheet, the names are given in the column multiple times over since it reflects each of the accounts these people have.

I'd like each individual name to only be included once each in this new column and for this column to auto-populate based upon the existing one.

What's the best way to go about this?

Thank you for any help.

Best Answer

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    Answer ✓

    You could insert a text/number column called "Number" then pre-fill it with as many rows as you feel comfortable with that you won't exceed.

    1

    2

    3

    4

    5

    so on and so forth...


    From there you would use this column formula to pull the names:

    =IFERROR(INDEX(DISTINCT({Source Sheet Name Column}), [email protected]), "")

    thinkspi.com

Answers

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    Answer ✓

    You could insert a text/number column called "Number" then pre-fill it with as many rows as you feel comfortable with that you won't exceed.

    1

    2

    3

    4

    5

    so on and so forth...


    From there you would use this column formula to pull the names:

    =IFERROR(INDEX(DISTINCT({Source Sheet Name Column}), [email protected]), "")

    thinkspi.com