Comparing two lists
Closed
Steve
-
Jan 28, 2012 at 10:59 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Jan 28, 2012 at 10:19 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Jan 28, 2012 at 10:19 PM
Related:
- Comparing two lists
- Display two columns in data validation list but return only one - Guide
- Excel compare two sheets - Guide
- Google maps lists - Guide
- Compare two worksheets and paste differences to another sheet - excel vba free download - Excel Forum
- Macro to compare 2 sheets and copy differences ✓ - Excel Forum
1 response
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Jan 28, 2012 at 10:19 PM
Jan 28, 2012 at 10:19 PM
suppose your sheet 1 is like this
data
1
2
3
4
5
6
7
8
in B2 type this formula(or copy paste)
=IF(COUNTIF(Sheet2!$A$1:$A$4,Sheet1!A2)=1,"yes","no")
copy B2 down.
modify formula depending upon the configuration of sheet 2(particularly the item "Sheet2!$A$1:$A$4"
data
1
2
3
4
5
6
7
8
in B2 type this formula(or copy paste)
=IF(COUNTIF(Sheet2!$A$1:$A$4,Sheet1!A2)=1,"yes","no")
copy B2 down.
modify formula depending upon the configuration of sheet 2(particularly the item "Sheet2!$A$1:$A$4"
