How to Search Duplicates in Excel

-
In today’s video we will show you how to search duplicates in Excel.
Open Excel file you need. We have a list of names with duplicates ready for this tutorial. Put your mouse in the Empty cell next to the data. Paste the formula into the line at the top of the document. You can find the formula in the description box below. Edit the value. For example, we have data in column A, from cell one to cell twenty-two. So, we edit formula values A1 to A22. Click somewhere on empty space in the document when you are ready.
Select a cell with the formula. Pull the bottom right corner down, for as far as you need. It will copy the formula for each cell. You will get Duplicate or No Duplicate note next to each cell.
Formula:

Видео How to Search Duplicates in Excel канала HOWZA TUTORIALS