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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
ProfessorJimJamMicrosoft Excel ExpertCommented:
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
OWASP: Avoiding Hacker Tricks

Learn to build secure applications from the mindset of the hacker and avoid being exploited.

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
ProfessorJimJamMicrosoft Excel ExpertCommented:
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
ProfessorJimJamMicrosoft Excel ExpertCommented:
I agree :-)

I am glad that ecnookami has resolved the issue
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.