Comparing two lists
Closed
Steve
-
28 Jan 2012 à 10:59
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 - 28 Jan 2012 à 22:19
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 - 28 Jan 2012 à 22:19
Related:
- Comparing two lists
- How to merge and compare two excel files - Guide
- Lists google maps - Guide
- Display two columns in data validation list but return only one - Guide
- Comparing two lists of names in Excel and then sorting them - Excel Forum
- Apps for christmas lists - Guide
1 response
venkat1926
Posts
1863
Registration date
Sunday 14 June 2009
Status
Contributor
Last seen
7 August 2021
811
28 Jan 2012 à 22:19
28 Jan 2012 à 22:19
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"
