Back to tutorials
Tag Collection
Google Sheets
2 tutorials grouped around Google Sheets, so readers can continue by topic.
operations
Google Sheets Deduplication: Functions, Conditional Formatting & Online Tools Comparison (UNIQUE / SORTN / QUERY)
Complete online collaborative data deduplication guide: Google Sheets built-in functions UNIQUE, SORTN, QUERY comparison, conditional formatting to mark duplicates, cross-sheet merge deduplication solutions. Suitable for Google Forms surveys, shared sheets, online collaboration scenarios.
12 min readAug 18, 2025
advanced
Research/Survey Data Batch Deduplication: Email/Organization/Time Window Composite Key Practice
Professional guide for academic research and survey data cleaning: handle duplicate responses, cross-batch merging, organization name standardization, time window deduplication. Support privacy compliance, retention rule configuration, audit tracking, suitable for academic research, market research, user feedback and other scenarios.
15 min readAug 18, 2025