• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Pivot table for invalid records

M

masurri

New Member
Hi Team,


I have two excel sheets with similar data, but there might be few records which may be differ in two excel sheets. So in the excel sheet i would like to show what are the records which are differing .So can you let me know how can i create a new excel sheet where it shows the differed records,


Thanks in advance,

masurri
 
If you search this site for "compare lists" you'll find that Chandoo has written several articles on this subject.


NOTE: Per the stickey posted this weekend, the blog is currently down, so you might not be able to get to the articles. If you need an answer right away, a regular Google search for "excel compare lists" might help you out.
 
You must log in or register to reply here.
Back
Top