asked on

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!!!

ASKER CERTIFIED SOLUTION

Saurabh Singh Teotia

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

Professor J

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Martin Liss

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.

Saurabh Singh Teotia

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

Professor J

Saurabh, :-)

it is not about points, it is about how solution is provided at the best possible way. :-)

Saurabh Singh Teotia

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

Professor J

I agree :-)

I am glad that ecnookami has resolved the issue