WPS Sheets Data Comparison Feature User Guide

Feature Summary

The data comparison feature is used to compare data differences between two ranges or two worksheets, quickly identifying discrepancies to facilitate data verification and validation.

Feature Description

Feature Dimension	Description
Membership Restriction	Membership required
Version Restriction	No version restriction

Operation Steps

Smart Toolbox - Mark Duplicate Data (Membership required)

Feature Entry
"Member Exclusive" tab → "Smart Toolbox" option → "Smart Toolbox" tab → "Data Comparison" dropdown menu → "Mark Duplicate Data" option

1. Select the data range to be compared
2. Select the Member Exclusive tab
3. Click the Smart Toolbox button
4. The Smart Toolbox tab pops up
5. Click the Data Comparison dropdown menu
6. Select the "Mark Duplicate Data" option
7. Set comparison parameters and comparison range
8. Click Confirm Marking
9. Duplicate data will be highlighted

Smart Toolbox - Extract Duplicate Data (Membership required)

Feature Entry
"Member Exclusive" tab → "Smart Toolbox" option → "Smart Toolbox" tab → "Data Comparison" dropdown menu → "Extract Duplicate Data" option

1. Select the data range to be compared
2. Select the Member Exclusive tab
3. Click the Smart Toolbox button
4. The Smart Toolbox tab pops up
5. Click the Data Comparison dropdown menu
6. Select the "Extract Duplicate Data" option
7. Set comparison parameters and comparison range
8. Click Extract to New Worksheet
9. Duplicate data will be extracted to a new worksheet

Smart Toolbox - Mark Unique Data (Membership required)

Feature Entry
"Member Exclusive" tab → "Smart Toolbox" option → "Smart Toolbox" tab → "Data Comparison" dropdown menu → "Mark Unique Data" option

1. Select the data range to be compared
2. Select the Member Exclusive tab
3. Click the Smart Toolbox button
4. The Smart Toolbox tab pops up
5. Click the Data Comparison dropdown menu
6. Select the "Mark Unique Data" option
7. Set comparison parameters and comparison range
8. Click Confirm Marking
9. Differing data will be highlighted

Smart Toolbox - Extract Unique Data (Membership required)

Feature Entry
"Member Exclusive" tab → "Smart Toolbox" option → "Smart Toolbox" tab → "Data Comparison" dropdown menu → "Extract Unique Data" option

1. Select the data range to be compared
2. Select the Member Exclusive tab
3. Click the Smart Toolbox button
4. The Smart Toolbox tab pops up
5. Click the Data Comparison dropdown menu
6. Select the "Extract Unique Data" option
7. Set comparison parameters and comparison range
8. Click Extract to New Worksheet
9. Unique data will be extracted to a new worksheet

Data Tab - Mark Duplicate Data (Membership required)

Feature Entry
"Data" tab → "Data Comparison" dropdown menu → "Mark Duplicate Data" option

1. Select the data range to be compared
2. Select the Data tab
3. Click the Data Comparison dropdown menu
4. Select the "Mark Duplicate Data" option
5. Set comparison parameters and comparison range
6. Click Confirm Marking
7. Duplicate data will be highlighted

Data Tab - Extract Duplicate Data (Membership required)

Feature Entry
"Data" tab → "Data Comparison" dropdown menu → "Extract Duplicate Data" option

1. Select the data range to be compared
2. Select the Data tab3. Click the Data Compare drop-down menu
3. Select the "Extract Duplicate Data" option
4. Set comparison parameters and comparison range
5. Click Extract to New Sheet
6. Duplicate data will be extracted to a new sheet

Data Tab - Mark Unique Data (Membership required)

Feature Entry
"Data" tab → "Data Compare" drop-down menu → "Mark Unique Data" option

1. Select the data range to compare
2. Select the Data tab
3. Click the Data Compare drop-down menu
4. Select the "Mark Unique Data" option
5. Set comparison parameters and comparison range
6. Click Confirm Mark
7. Differing data will be highlighted

Data Tab - Extract Unique Data (Membership required)

Feature Entry
"Data" tab → "Data Compare" drop-down menu → "Extract Unique Data" option

1. Select the data range to compare
2. Select the Data tab
3. Click the Data Compare drop-down menu
4. Select the "Extract Unique Data" option
5. Set comparison parameters and comparison range
6. Click Extract to New Sheet
7. Unique data will be extracted to a new sheet

Notes

• Ensure data structure consistency before comparing
• Comparison results can be exported or marked