Forum Discussion
Vijayakumar_Natarajan
Jan 04, 2024Copper Contributor
Comparing the data in same excel sheet
Hi All, Happy New Year 2024! I have a target list with the company website, first name, last name, business email, and LinkedIn URL of contacts. Is it possible to check whether the informatio...
AshaKantaSharma
Aug 20, 2024Iron Contributor
Set up data validation rules to ensure that entries meet specific criteria.
Email Validation:
Select the column with email addresses.
Go to Data > Data Validation.
Set the criteria to allow only emails (you can use a custom formula like =AND(ISNUMBER(FIND("@", A1)), ISNUMBER(FIND(".", A1)))).
URL Validation:
For LinkedIn URLs, you might use a custom formula to ensure they start with "https://www.linkedin.com/".
Use a formula like =LEFT(A1, 26)="https://www.linkedin.com/" for URL validation.
Email Validation:
Select the column with email addresses.
Go to Data > Data Validation.
Set the criteria to allow only emails (you can use a custom formula like =AND(ISNUMBER(FIND("@", A1)), ISNUMBER(FIND(".", A1)))).
URL Validation:
For LinkedIn URLs, you might use a custom formula to ensure they start with "https://www.linkedin.com/".
Use a formula like =LEFT(A1, 26)="https://www.linkedin.com/" for URL validation.