Compare 2 sheets
Closed
Swati Nayak
Posts
3
Registration date
Wednesday April 17, 2013
Status
Member
Last seen
April 17, 2013
-
Apr 17, 2013 at 02:44 AM
Zohaib R Posts 2368 Registration date Sunday September 23, 2012 Status Member Last seen December 13, 2018 - Apr 17, 2013 at 05:42 AM
Zohaib R Posts 2368 Registration date Sunday September 23, 2012 Status Member Last seen December 13, 2018 - Apr 17, 2013 at 05:42 AM
Related:
- Compare 2 sheets
- Tentacle locker 2 - Download - Adult games
- Fnia 2 - Download - Adult games
- Euro truck simulator 2 download free full version pc - Download - Simulation
- Feeding frenzy 2 download - Download - Arcade
- Resident evil 2 remake free download - Download - Horror
6 responses
Zohaib R
Posts
2368
Registration date
Sunday September 23, 2012
Status
Member
Last seen
December 13, 2018
69
Apr 17, 2013 at 03:00 AM
Apr 17, 2013 at 03:00 AM
Hi Swati Nayak,
You can use Microsoft Excel's VLOOKUP() worksheet function in combination with ISNA() worksheet function to compare two columns. I have tried to answer one of the users in the forum who had a similar query. Please refer to the below mentioned thread:
https://ccm.net/forum/affich-694189-i-would-like-to-compare-2-columns
If the post in the above link is not clear, please upload your sample to data speedyshare.com by clicking here.
Note: please do not upload any file which has any type of personal or confidential data as this is an open forum.
Please revert for clarification.
You can use Microsoft Excel's VLOOKUP() worksheet function in combination with ISNA() worksheet function to compare two columns. I have tried to answer one of the users in the forum who had a similar query. Please refer to the below mentioned thread:
https://ccm.net/forum/affich-694189-i-would-like-to-compare-2-columns
If the post in the above link is not clear, please upload your sample to data speedyshare.com by clicking here.
Note: please do not upload any file which has any type of personal or confidential data as this is an open forum.
Please revert for clarification.
Swati Nayak
Posts
3
Registration date
Wednesday April 17, 2013
Status
Member
Last seen
April 17, 2013
Apr 17, 2013 at 03:18 AM
Apr 17, 2013 at 03:18 AM
Hi Zohaib,
Actually there are multiple files and huge data to be compared, and for every file the reference would be different. Is there any other way??
Thanks & Regards,
Swati
Actually there are multiple files and huge data to be compared, and for every file the reference would be different. Is there any other way??
Thanks & Regards,
Swati
sgmpatnaik
Posts
52
Registration date
Tuesday April 2, 2013
Status
Member
Last seen
November 27, 2013
45
Apr 17, 2013 at 04:01 AM
Apr 17, 2013 at 04:01 AM
@Swati
Hi
Is it possible to upload a sample file
Thanks
Patnaik
Hi
Is it possible to upload a sample file
Thanks
Patnaik
Zohaib R
Posts
2368
Registration date
Sunday September 23, 2012
Status
Member
Last seen
December 13, 2018
69
Apr 17, 2013 at 04:33 AM
Apr 17, 2013 at 04:33 AM
Hi Swati,
Is there a common column in the two sheets which can be used as a Primary Key? In other words is there a column which has unique values and is present in both the sheets? Check the following example:
A B C
1 AB CA
2 BA BA
3 AC BA
4 CA AC
In the above example Column A is the Primary Key as this has unique values and the values will not repeat.
Please do write back to us.
Is there a common column in the two sheets which can be used as a Primary Key? In other words is there a column which has unique values and is present in both the sheets? Check the following example:
A B C
1 AB CA
2 BA BA
3 AC BA
4 CA AC
In the above example Column A is the Primary Key as this has unique values and the values will not repeat.
Please do write back to us.
Didn't find the answer you are looking for?
Ask a question
Swati Nayak
Posts
3
Registration date
Wednesday April 17, 2013
Status
Member
Last seen
April 17, 2013
Apr 17, 2013 at 04:45 AM
Apr 17, 2013 at 04:45 AM
Hi,
Yes it has a unique employee ID.
Regards, Swati
Yes it has a unique employee ID.
Regards, Swati
Zohaib R
Posts
2368
Registration date
Sunday September 23, 2012
Status
Member
Last seen
December 13, 2018
69
Apr 17, 2013 at 05:42 AM
Apr 17, 2013 at 05:42 AM
Hi Swati,
There is an article from "office.microsoft.com", this article addresses a similar issue. Please check the below mentioned link and see if this can save your time:
http://office.microsoft.com/en-in/excel-help/use-excel-to-compare-two-lists-of-data-HA001103915.aspx
Do reply with results.
There is an article from "office.microsoft.com", this article addresses a similar issue. Please check the below mentioned link and see if this can save your time:
http://office.microsoft.com/en-in/excel-help/use-excel-to-compare-two-lists-of-data-HA001103915.aspx
Do reply with results.