Database help! Copying new names to another sheet

lisa.bolger27646

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!

Paul Newcome

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), "")

lisa.bolger27646

Hi Paul,

Thank you for your advice. I will try this! I may come back with questions!!

Lisa

Paul Newcome

Happy to help. 👍️