Forum Discussion

Vijayakumar_Natarajan's avatar
Vijayakumar_Natarajan
Copper Contributor
Jan 04, 2024

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 information added against them is correct or incorrect? Your input would add value to my work schedule.

 

Thank you!

excel
  • AshaKantaSharma's avatar
    AshaKantaSharma
    Iron Contributor
    Aug 20, 2024
    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.

Resources