Dealing with Duplicates in Excel and Finding Unique Data

[@danielkyaligonza53]

Thanks for sharing, you make all of us become better

[@luisfernandoaguilar3388]

I'm amazed with your videos!

[@babalooo]

I love that you use New Wave as your examples :)

[@wazmink2459]

All your vlog and tutorial are very very helpful

[@noorulain7302]

Great video........ Appreciate from the core of heart.......

[@felixvincent643]

lets say you wanna delete the duplicate lines BUT keep the data from the sales and copies sold columns, because this data is important, can you keep the data AND delete the duplicate?

[@sanjaydsouza7123]

Using item number would be a better unique identifier while removing duplicates.

[@dayakardorepalli8834]

How to copy the duplicate & unique values in another excel file or sheet.

[@விஜய்-ச4ட]

First filter it on same sheet and then only you can it to a new sheet. Because it isn't allowing to copy the filtered data directly in new sheet.

[@jayanthjosh8788]

Thanks a lot....It solved my issue...

[@electrovoltmce]

how do I disable the option to detect duplicate values ​​in excel - how do I disable this option - I want to have duplicate values????

[@giorgizedginidze8220]

please insert an example file to go with the video

[@alic4631]

I'm here for the synthpop playlist 😂

[@srinjoydas6644]

Thank you so much!

[@ankumar3710]

thank you so much Mr.

[@nirmalmaharjan1748]

thanks. Really helped me. cheers!!!

[@danielkyaligonza53]

Wonderful

[@WhatsHisFace2013]

I come for the Excel. I stay for the running gag of Synthpop & New Wave.

[@salahlakhdar6714]

anyone can share with me the link of data used in the video.

[@rakibulhaque3444]

Thanks

[@granddeluxe123]

can you help me with duplicate? I made sequence on a coloumn e.g 1.1, 1.2, 1.3 etc. But the the duplicates highlighted 1.13 and 1.1 the same and also 1.2 and 1.20. How to make a rule to stop highlighting 1.1 and 1.2

[@moti2255]

Great video, how do you get rid of the colors afterward?

[@hudbaoir3610]

SImply highlight all the cells and go to Conditional Formating -> remove rules from selected cells

[@monal.1485]

Hi I am trying to find a video on Index and Match, I don

[@harkeshsharma3264]

Great. 👌

[@alokghosh9311]

Very Good...