How to quickly find duplicate values in Excel
I think the best way to find duplicate records is using Conditional Formatting and Filter. It’s easy, simple and fast. Continue reading “How to quickly find duplicate values in Excel” »
How many times are the values in the table?
There is an easy way to find number of occurrences of items in the table. For example, the following table contains repeated Products. We want to know, how many times was each product ordered.
Continue reading “How many times are the values in the table?” »
Tags: Pivot Table
Delete duplicate rows
This example shows how to remove duplicate rows from a table. In the following table you can see two duplicate rows. It’s row number 2, 9, 10 and 3, 6.
Tags: Advanced Filter
