candymycandy
New Member
- Joined
- Jun 14, 2022
- Messages
- 17
- Office Version
- 365
- Platform
- Windows
I have a spreadsheet where multiple users are entering company names in one of the columns, based on customers signing up for an event.
I have a formula to extract the company name from the email address, but users can also manually overwrite this.
The issue is, users have started to record different variations of the same company, so it skews the data on pivot tables etc. For example, one user will write "A New Company" but there will already be an instance of "ANewCompany" which has been extracted from an email address.
Is there a way to highlight to the users if there is a partial match already been entered so they can check which version of the name to use? Either in a separate column or with formatting in the same column?
An example of what I mean is here: book2
Thank you in advance
I have a formula to extract the company name from the email address, but users can also manually overwrite this.
The issue is, users have started to record different variations of the same company, so it skews the data on pivot tables etc. For example, one user will write "A New Company" but there will already be an instance of "ANewCompany" which has been extracted from an email address.
Is there a way to highlight to the users if there is a partial match already been entered so they can check which version of the name to use? Either in a separate column or with formatting in the same column?
An example of what I mean is here: book2
Thank you in advance