# 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!!!
###### Who is Participating?

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.

Commented:
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

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

Microsoft Excel ExpertCommented:

just add your data in columns there as shown and then copy the formula down.
Comparing-3-Sheets-with-Formula.xlsx
0
Older 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
Commented:
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
Microsoft Excel ExpertCommented:
Saurabh,   :-)

it is not about points, it is about how solution is provided at the best possible way. :-)
0
Commented:
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
Microsoft 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.