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
-
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}), Number@row), "")
Answers
-
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}), Number@row), "")
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!