Comparing columns
Closed
cl1425
Posts
1
Registration date
Thursday December 5, 2013
Status
Member
Last seen
December 5, 2013
-
Dec 5, 2013 at 12:52 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Dec 6, 2013 at 04:17 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Dec 6, 2013 at 04:17 AM
Related:
- Comparing columns
- Display two columns in data validation list but return only one - Guide
- Excel change columns to numbers - Guide
- Excel compare two columns for partial matches - Guide
- Google sheets right to left columns - Guide
- Insert a new sheet at the end of the tab names and paste the range names starting in cell a1. autofit columns a:b and name the worksheet as range names. ✓ - Excel Forum
1 response
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Dec 6, 2013 at 04:17 AM
Dec 6, 2013 at 04:17 AM
see samples data in col B and C . the formula is in D2 which is copied down
the formula in D2 is
=IF(ISERROR(MATCH(B2,$C$2:$C$11,0)),IF(B2="","","N/A"),"common")
download data from
http://speedy.sh/RnDHU/cl1425.xlsx
the formula in D2 is
=IF(ISERROR(MATCH(B2,$C$2:$C$11,0)),IF(B2="","","N/A"),"common")
download data from
http://speedy.sh/RnDHU/cl1425.xlsx
