Excel: Partial Matches in 2 Different Cells
Solved/Closed
kaiwalls04
Posts
6
Registration date
Friday April 4, 2014
Status
Member
Last seen
May 1, 2014
-
Apr 9, 2014 at 03:58 PM
kaiwalls04 Posts 6 Registration date Friday April 4, 2014 Status Member Last seen May 1, 2014 - Apr 10, 2014 at 11:53 AM
kaiwalls04 Posts 6 Registration date Friday April 4, 2014 Status Member Last seen May 1, 2014 - Apr 10, 2014 at 11:53 AM
Related:
- Excel: Partial Matches in 2 Different Cells
- Excel marksheet - Guide
- Number to words in excel - Guide
- Excel apk for pc - Download - Spreadsheets
- Kernel for excel - Download - Backup and recovery
- Gif in excel - Guide
1 response
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Apr 10, 2014 at 07:43 AM
Apr 10, 2014 at 07:43 AM
try this formula in thefirst M cell and copy dowan
=IF(ISNUMBER(SEARCH(K1,L1)),"match","nomatch")
=IF(ISNUMBER(SEARCH(K1,L1)),"match","nomatch")
Apr 10, 2014 at 11:53 AM