How to populate a column in a sheet based on a column from another?
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.
Help Article Resources
Check out the Formula Handbook template!