Forum Discussion
Mahdia_Akter
Mar 15, 2022Copper Contributor
Name Search in Excel
I have say one worksheet (say A) where there are names such as:
1. Aby Gomes
2. Jacob Hunter Streep
3. Gomes Jake Leo
4. Ms Margot Robert
5. Ms Selena Leo
6. Dianne Cobb
Another worksheet (B)
1. Drake Joseph
2. Dianne Celeb
3. Peter Aby Gomes
4. Streep Jacob Hunter
5. Cobb, Dianne
6. Ms Leo
7. Drake Cobb
8. Nill Manderson
Data in my excel files are like this, is there any way I can use a function to find if a certain name in worksheet A exists in worksheet B or not. I need to find a partial match (even if they are not the same person i just need the partial matching names highlighted) also is there any way to find by their calling names like Aby, Jacob, Leo etc?
1. Aby Gomes
2. Jacob Hunter Streep
3. Gomes Jake Leo
4. Ms Margot Robert
5. Ms Selena Leo
6. Dianne Cobb
Another worksheet (B)
1. Drake Joseph
2. Dianne Celeb
3. Peter Aby Gomes
4. Streep Jacob Hunter
5. Cobb, Dianne
6. Ms Leo
7. Drake Cobb
8. Nill Manderson
Data in my excel files are like this, is there any way I can use a function to find if a certain name in worksheet A exists in worksheet B or not. I need to find a partial match (even if they are not the same person i just need the partial matching names highlighted) also is there any way to find by their calling names like Aby, Jacob, Leo etc?
2 Replies
Sort By
- EricStarkerFormer Employee
Mahdia_Akter Hello! You've posted your question in the Tech Community Discussion space, which is intended for discussion around the Tech Community website itself, not product questions. I'm moving your question to the Excel space - please post Excel questions here in the future.
- Mahdia_AkterCopper ContributorSure, i didn't know that. Apologies.