Excel: matching lists with different formats
Closed
KnitClown
Posts
1
Registration date
Tuesday September 24, 2013
Status
Member
Last seen
September 24, 2013
-
Sep 24, 2013 at 03:34 PM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Sep 25, 2013 at 11:11 AM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Sep 25, 2013 at 11:11 AM
I have two lists of names that I am trying to compare. One list is divided into two cells, one for first and one for last names. The other list has the names written last name, first name. I would like to compare the lists and find out what names match. The formula =ISNA(MATCH(E1,A:A,0) ) worked for two lists of names that are formatted the same. Is there a way to request a partial match?
Thanks for your help. What a great resource this list has been!
Thanks for your help. What a great resource this list has been!
Related:
- Excel: matching lists with different formats
- Excel mod apk for pc - Download - Spreadsheets
- Number to words in excel - Guide
- Gif in excel - Guide
- Kernel for excel - Download - Backup and recovery
- Excel marksheet - Guide
1 response
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Sep 25, 2013 at 11:11 AM
Sep 25, 2013 at 11:11 AM
KnitClown, Good morning.
I did an example to help solving your question.
https://www.cjoint.com/c/CIzriDRuKbK
Take a look at it and tell us if it worked for you.
I hope it helps you.
Greetings from Brazil.
I did an example to help solving your question.
https://www.cjoint.com/c/CIzriDRuKbK
Take a look at it and tell us if it worked for you.
I hope it helps you.
Greetings from Brazil.