Back to tutorials
Tag Collection
UNIQUE
2 tutorials grouped around UNIQUE, so readers can continue by topic.
operations
Excel Deduplication with Keep Rules: Retain First/Latest Record Guide
Comprehensive guide to Excel deduplication retention rules: keep first, keep latest, keep max value, multi-tier rules. Provides SheetCleaner, Power Query, and Excel 365 formula implementations with complete examples and best practices.
12 min readAug 18, 2025
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