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
Hi,

I have two excel sheets that i need to compare. The problem is that the column headers of sheet 1 doesn't match with the column headers of sheet 2. Another problem is the order in which the columns are pasted in sheet 1 is different in sheet 2. I really need it asap if you could help.

Thanks in advance! :)

6 replies

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
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.
0
Swati Nayak Posts 3 Registration date Wednesday April 17, 2013 Status Member Last seen April 17, 2013
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
0
sgmpatnaik Posts 54 Registration date Tuesday April 2, 2013 Status Member Last seen November 27, 2013 45
Apr 17, 2013 at 04:01 AM
@Swati

Hi

Is it possible to upload a sample file

Thanks

Patnaik
0
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
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.
0

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
Hi,

Yes it has a unique employee ID.

Regards, Swati
0
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
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.
0