russrokicki
New Member
- Joined
- Feb 18, 2014
- Messages
- 4
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
<tbody>
</tbody><colgroup><col><col><col span="3"><col><col></colgroup>
Any advice is greatly appreciated!
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!