To compare cells of two columns
Closed
GD
-
Mar 18, 2011 at 05:34 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Mar 18, 2011 at 07:23 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Mar 18, 2011 at 07:23 AM
Related:
- To compare cells of two columns
- Beyond compare - Download - File management
- Display two columns in data validation list but return only one - Guide
- Tweetdeck larger columns - Guide
- Excel compare two sheets - Guide
- Compare two worksheets and paste differences to another sheet - excel vba free download ✓ - Excel Forum
1 response
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Mar 18, 2011 at 07:23 AM
Mar 18, 2011 at 07:23 AM
suppose data is like thsi
Solar |system solar
Excel | inc excel
Excel | excel
Rich | Rich
Apple | Door
in C1 type this formula
=IF(ISNUMBER(SEARCH(A1,B1)),"match","not macth")
copy c1 down and see
Solar |system solar
Excel | inc excel
Excel | excel
Rich | Rich
Apple | Door
in C1 type this formula
=IF(ISNUMBER(SEARCH(A1,B1)),"match","not macth")
copy c1 down and see