Database help! Copying new names to another sheet
Hello,
We have an intake sheet to manage requests for employees to work on projects. This intake sheet wmay have an employee listed for one or multiple projects and we would like to keep use this intake sheet to source a database where there should just be one row per employee.
Is there a formula to help copy just the new employees so there are no duplicates in the database?
Happy to provide any other details.
Thank you!
Answers
-
You would insert a text/number column (called "Number" in this example) and manually enter the numbers 1 through whatever (however many you think you will need plus a buffer) and then use this column formula to generate the list you are looking for:
=IFERROR(INDEX(DISTINCT({Main Sheet Name Column}), Number@row), "")
-
Hi Paul,
Thank you for your advice. I will try this! I may come back with questions!!
Lisa
-
Happy to help. 👍️
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
- 145 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!