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
- Tweetdeck larger columns - Guide
- Display two columns in data validation list but return only one - Guide
- How to delete columns in word - Guide
- Excel columns changed to numbers - Guide
- Excel partial text match between two columns - Guide
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
