How to Use WPS Data Comparison on Windows

Use WPS Data Comparison through 8 how-to topics, with all 8 topics membership-related and available from the index below.

How-to Index

How-to Guide

1. Smart Toolbox - Mark Duplicate Data

Entry path: Member Exclusive → Smart Toolbox → Data Comparison → Mark Duplicate Data

1. Select the data range that you want to compare.
2. Click the Member Exclusive tab.
3. Click Smart Toolbox.
4. Open the Data Comparison menu and select Mark Duplicate Data.
5. Set the comparison parameters and comparison range.
6. Click Confirm Marking.
7. Review the highlighted duplicate data.

Success Criteria

• Duplicate entries are highlighted in the selected range.
• You can continue reviewing, editing, or saving the worksheet.

Tips While Using

• This topic requires an active membership account.
• Check that the selected data structure is comparable before you start.

2. Smart Toolbox - Extract Duplicate Data

Entry path: Member Exclusive → Smart Toolbox → Data Comparison → Extract Duplicate Data

1. Select the data range that you want to compare.
2. Click the Member Exclusive tab.
3. Click Smart Toolbox.
4. Open the Data Comparison menu and select Extract Duplicate Data.
5. Set the comparison parameters and comparison range.
6. Click Extract to New Worksheet.
7. Review the extracted duplicate data in the new worksheet.

Success Criteria

• A new worksheet is created.
• Duplicate data is extracted into the new worksheet.

Tips While Using

• This topic requires an active membership account.
• Confirm that the selected range is complete before extracting results.

3. Smart Toolbox - Mark Different Data

Entry path: Member Exclusive → Smart Toolbox → Data Comparison → Mark Different Data

1. Select the data range that you want to compare.
2. Click the Member Exclusive tab.
3. Click Smart Toolbox.
4. Open the Data Comparison menu and select Mark Different Data.
5. Set the comparison parameters and comparison range.
6. Click Confirm Marking.
7. Review the highlighted different data.

Success Criteria

• Different entries are highlighted.
• You can continue checking the mismatched items manually.

Tips While Using

• This topic requires an active membership account.
• Make sure the two ranges or worksheets are comparable.

4. Smart Toolbox - Extract Different Data

Entry path: Member Exclusive → Smart Toolbox → Data Comparison → Extract Different Data

1. Select the data range that you want to compare.
2. Click the Member Exclusive tab.
3. Click Smart Toolbox.
4. Open the Data Comparison menu and select Extract Different Data.
5. Set the comparison parameters and comparison range.
6. Click Extract to New Worksheet.
7. Review the extracted different data in the new worksheet.

Success Criteria

• A new worksheet is created.
• Different data is extracted into the new worksheet.

Tips While Using

• This topic requires an active membership account.
• The extracted result is useful for summaries and exports.

5. Data Tab - Mark Duplicate Data

Entry path: Data → Data Comparison → Mark Duplicate Data

1. Select the data range that you want to compare.
2. Click the Data tab.
3. Open the Data Comparison menu.
4. Select Mark Duplicate Data.
5. Set the comparison parameters and comparison range.
6. Click Confirm Marking.
7. Review the highlighted duplicate data.

Success Criteria

• Duplicate data is highlighted.
• The current worksheet remains editable.

Tips While Using

• This topic requires an active membership account.
• If there are many results, use filters for follow-up review.

6. Data Tab - Extract Duplicate Data

Entry path: Data → Data Comparison → Extract Duplicate Data

1. Select the data range that you want to compare.
2. Click the Data tab.
3. Open the Data Comparison menu.
4. Select Extract Duplicate Data.
5. Set the comparison parameters and comparison range.
6. Click Extract to New Worksheet.
7. Review the duplicate data in the new worksheet.

Success Criteria

• A new worksheet is created.
• Duplicate data is output separately for easier cleanup.

Tips While Using

• This topic requires an active membership account.
• You can continue editing or saving the new worksheet after extraction.

7. Data Tab - Mark Different Data

Entry path: Data → Data Comparison → Mark Different Data

1. Select the data range that you want to compare.
2. Click the Data tab.
3. Open the Data Comparison menu.
4. Select Mark Different Data.
5. Set the comparison parameters and comparison range.
6. Click Confirm Marking.
7. Review the highlighted different data.

Success Criteria

• Different data is highlighted.
• You can continue locating and handling mismatched items.

Tips While Using

• This topic requires an active membership account.
• For reconciliation work, backing up the original worksheet first is helpful.

8. Data Tab - Extract Different Data

Entry path: Data → Data Comparison → Extract Different Data

1. Select the data range that you want to compare.
2. Click the Data tab.
3. Open the Data Comparison menu.
4. Select Extract Different Data.
5. Set the comparison parameters and comparison range.
6. Click Extract to New Worksheet.
7. Review the different data in the new worksheet.

Success Criteria

• A new worksheet is created.
• Different data is extracted separately for later analysis.

Tips While Using

• This topic requires an active membership account.
• The extracted result can be used as a review list for differences.