How to Sort and Find duplicates in Excel

Thank You In 2021!

How you short data please show

I just added this old video, (which is still very useful for spreadsheet work to remove duplicates),  to a new Playlist called "Other How-To Videos (Not Skype Related)". I will add the link to the playlist in the show more decription under the video. 

I looked it up 3 years)) Thank you!!!

thank u so much for this video it really helped!

Great! Thanks!

@thuynguyenable yes there is, highlight table, go to home ribbon, conditional formatting, highlight cell rules, duplicate values. This will work on Microsoft excel 2007/2010. hope this helps

sorting initially should set it up to avoid that

I do not think so, but will ask Russ to comment.

Thank YOU! Good idea. Skype me to help me set one up? PayPal has?

You should have a donate link. Thank you so much.

Thanks for the video. You are the man, you must conquer many women with your elite excel skills!