Need help Finding differences / duplicates in two worksheets

[russrokicki]

I have two worksheets which consist of password lists. One sheet has 5100 rows while the other has 1200

I need to determine which data is not represented from the one worksheet in the 1st and also need to find duplicates in the sheets and finally to find data that has been changed so the User will exist as well as the resource but the login credentials are different.

Is there a way to do this using scripts?

I guess i would first want to identify all duplicates.
Then I would want to identify all missing information (what users are not represented at all in the second sheet)
and then finally identify users that are on both worksheets with different information in the credentials fields.

both sheets have the same headings

Resource /

Username /

First / Name

Last / Name

Name /

Res Username /

Password

<tbody>
</tbody><colgroup><col><col><col span="3"><col><col></colgroup>

Any advice is greatly appreciated!

 

[ask2tsp]

One sheet has 5100 rows while the other has 1200

What are these two lists? Where do they come from? Why is it possible that there are duplicates?

from the one worksheet in the 1st

I do not understand what that means. Please try to explain in another way.

i would first want to identify all duplicates.

Only identify them or also remove the dups?

identify users that are on both worksheets with different information in the credentials fields.

Do you mean rows where Resource / Username are the same and Res Username / Password differ?

 

[hiker95]

russrokicki,

Welcome to the MrExcel forum.


We would like more information. Please see the Forum Use Guidelines in the following link:

http://www.mrexcel.com/forum/board-announcements/127080-guidelines-forum-use.html


See reply #2 at the next link, if you want to show small screenshots, of the raw data, and, what the results should look like.

http://www.mrexcel.com/forum/about-board/508133-attachments.html#post2507729


Or, you can post your workbook/worksheets to the following free site (sensitive data changed), mark the workbook for sharing, and, provide us with a link to your workbook:

https://dropbox.com