How to Highlight Duplicates in Excel with AI | Real E-commerce Dataset

Learn how to highlight duplicates in Excel, then handle the harder real-world cases with Excel AI like RowSpeak.

In this demo, I use the public Olist e-commerce dataset to show how duplicate checks work across multiple files: customers, orders, and order items. You’ll see why basic Excel Conditional Formatting is useful for simple duplicates, but not enough when duplicates span files, IDs, and business rules.

Test dataset used in this video:
Customers CSV:
https://huggingface.co/datasets/miminmoons/olist-ecommerce-for-delivery-and-review-prediction/resolve/main/data/olist_customers_dataset.csv?download=true

Orders CSV:
https://huggingface.co/datasets/miminmoons/olist-ecommerce-for-delivery-and-review-prediction/resolve/main/data/olist_orders_dataset.csv?download=true

Order Items CSV:
https://huggingface.co/datasets/miminmoons/olist-ecommerce-for-delivery-and-review-prediction/resolve/main/data/olist_order_items_dataset.csv?download=true

Full tutorial:
https://rowspeak.ai/blog/highlight-duplicates-excel/

#Excel #ExcelTips #DataCleaning #AIforExcel #RowSpeak

Видео How to Highlight Duplicates in Excel with AI | Real E-commerce Dataset канала neu gls