Find Duplicates in Excel 2010 & 2013

Please Change Video Quality.

Excel's conditional formatting feature is an easy way to add special formatting features to specific areas of your spreadsheets. Depending on the value in a cell, you can change things like the font color of specific data or alter the background color of a cell (or cells).

The "conditional" part of the name means that you can control when and where the formatting changes are applied. If the data meets a certain condition, then the formatting change occurs.

One common use for this feature is to find duplicate data such as duplicate names, dates, or formulas in large tables of data.

[hrnaveenk]

Had I not watched this video, I may have ended up spending hours of time. Thank you so much.

[vinny]

Straight and to the point! Domo Arigato Mr. Roboto!

[ryanfrost]

great video! Thanks for saving my time and helping me filter out what data I need.

[rajmohan]

Thanks Bro, this is we want what we expect you gave us very simply, it really very well and helpful me hats off you Mr., ( some one make video like own history and not useful for who search here for help )

[accountsunitjapl]

THANK BRO WITH YOUR HELP I SOLVE ONE PROBLEM THANX AGAIN

[konarkgupta]

this is excelent, thanks very much, lets post more and more videos to help the

[saikiranuriti]

Thank you so much for helping me on my interview

[MdDinIslam]

That's really easy to find out. Thanks!!

[villejohn]

Thanks a lot man. you saved me a lot of time.

[pinkigupta]

u r right will not work for huge database

[vijkid]

at 0:53 When Unique is selected it should show one value from duplicate values as well right. In this Case one value from Stephen and one value from Lucy should be displayed along with single values

[vijayvj]

please do the video on how to merge new names with old names

[abduljabbarkhan]

if there is a 0 (zero) value in one of the columns and not in the other columns, all the 0 values in that particular column is also highlighted although there is no duplicate of this value. How to solve?

[amitvira]

How do I check for duplicates if I have 200+ rows of data, and I want to check for duplicates for in a ROW.

As in...I want to check row 1 ONLY for duplicates then check row 2 ONLY for duplicates then check row 3 ONLY for duplicates. But I want to do this for 200+ row of data. I don't want to do this 200 times checking row by row.

How can I do this in bulk?

[rajmohan]

could you post a video in same excel, the number is already entered

[kennynowell]

wow ... now that I know this I'll never wash spiders down the plughole.

[mattondatv]

I didn't know Hawkins was in the Excel training business