Finding difference between two worksheets

Can someone please suggest how to find difference between two excelsheets that basically have few additional rows.
For Example ...I have two identical sheets...in which one has 1760 rows and the other one has 1763 rows.
How to quickly find the three rows that is not present in the other one???

Thanks So much!!!
jen RadAsked:
Who is Participating?
 
Saurabh Singh TeotiaCommented:
Assuming you want to compare basis of A Column in Sheet-2 which has 1763 you can just apply this formula...

In b2 or any other cell which is empty and drag this further

=Countif(Sheet1!A:A,Sheet2!a2)

Now post which apply a filter all those values which are zero which will give you a count of all the values which are their in this sheet but not their in sheet1..

Saurabh...
0
 
ProfessorJimJamCommented:
please see attached.

just add your data in columns there as shown and then copy the formula down.
Comparing-3-Sheets-with-Formula.xlsx
0
 
Martin LissOlder than dirtCommented:
I've requested that this question be closed as follows:

Accepted answer: 500 points for ProfessorJimJam's comment #a40758110

for the following reason:

This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
0
Introducing Cloud Class® training courses

Tech changes fast. You can learn faster. That’s why we’re bringing professional training courses to Experts Exchange. With a subscription, you can access all the Cloud Class® courses to expand your education, prep for certifications, and get top-notch instructions.

 
Saurabh Singh TeotiaCommented:
I think the solution which i provided to him also works so in this case their should be split of points between me and jim..
0
 
ProfessorJimJamCommented:
Saurabh,   :-)

it is not about points, it is about how solution is provided at the best possible way. :-)
0
 
Saurabh Singh TeotiaCommented:
Jim..

I know it has been never for points..to me the solution which works..no marks for presentation..that all matters.. and on EE i have i seen that numerous times .. :-)

Saurabh...
0
 
ProfessorJimJamCommented:
I agree :-)

I am glad that ecnookami has resolved the issue
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.