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
- If two cells match return value from third excel ✓ - Excel Forum
- Compare two worksheets and paste differences to another sheet - excel vba free download - Excel Forum
- Conditional formatting if two cells match ✓ - 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
