How to Compare two excel sheets
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
21-01-18 11:46 PM
Can any one help me on below scenario.
we need to compare two Excel sheets.
Ant idea on - how to implement.
Thanks in advance
3 REPLIES 3
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
23-01-18 10:11 AM
Compare in what sense? What differences are you looking for?
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
25-01-18 01:38 PM
yeah I want mismatches from my master sheet.
here is my scenario - should export data from sap (export as a spread sheet) and internally we have one master sheet.
so i have to compare these two and should report mismatches.
any clue.
thanks in advance
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
26-01-18 03:53 PM
Maybe importing the sheets to collections and then comparing field by field, row by row?
