WPS Data Comparison on Windows FAQ

Common questions about WPS Data Comparison usually involve membership access, result types, and where to find the feature; this section covers 5 frequent questions and a glossary.

FAQ

Why can't I find the Data Comparison entry?

1. Make sure you are using WPS Spreadsheets on Windows.
2. Open a spreadsheet file and switch to the worksheet you want to work with.
3. Check the Data tab or Smart Toolbox under Member Exclusive.
4. Make sure your account is signed in; if you want to use the feature, also confirm that your membership is active.

Does Data Comparison require membership?

1. Yes. The feature description indicates that membership is required.
2. If your account does not have membership access, the related entry may not be available for use.
3. After signing in with an active membership account, open the Data Comparison menu again.

What is the difference between Mark Duplicate Data and Extract Duplicate Data?

1. Mark Duplicate Data highlights repeated items in the original range.
2. Extract Duplicate Data outputs repeated items into a new worksheet.
3. Use marking when you want to review results in place, and use extraction when you want a separate result sheet.

When should I use Mark Different Data or Extract Different Data?

1. Mark Different Data is suitable when you want to locate mismatched items directly in the original sheet.
2. Extract Different Data is suitable when you want to summarize mismatched items in a separate worksheet.
3. Both are useful for reconciliation, cross-sheet checks, and version review work.

Why are extracted results placed in a new worksheet?

1. Extraction actions output results separately for easier follow-up work.
2. This helps reduce interference with the original data range.
3. A new worksheet is also more convenient for reporting, exporting, or additional filtering.

Glossary