Remove Duplicates Within a Cell in Excel (2 Easy Ways)

Подписаться 374 тыс.

Просмотров 5 тыс.

50% 1

In this video, I will show you how to remove duplicates from a cell in Excel using formulas.
While removing duplicates from a range of cells where each value is in a different cell is quite easy, when it comes to removing duplicate items within a cell, you need to somehow analyze the entire content of the cell and then remove the duplicate values.
Thankfully, this can quickly be done using new Excel functions such as TEXTSPLIT, UNIQUE, and TEXTJOIN.
And if you do not have access to these new functions, you can create your own function using a simple VBA code.
VBA code available here - trumpexcel.com/remove-duplica...
00:00 Intro
00:00 Using TEXTSPLIT, UNIQUE and TEXTJOIN
00:00 Using VBA to create custom function
☕ If you find my Excel videos useful and would like to support me, you can buy me a coffee - www.buymeacoffee.com/SumitB
✅ Free Excel Course (Basic to Advanced) - trumpexcel.com/learn-excel/
✅ Free Dashboard Course - bit.ly/free-excel-dashboard-c...
✅ Free VBA course - bit.ly/excel-vba-course
✅ Free Power Query Course - bit.ly/power-query-course
✅ Best Excel Books: trumpexcel.com/best-excel-books/
Subscribe to get awesome Excel Tips every week: ru-vid.com...
#Excel #ExcelTips #ExcelTutorial #SumitBansal

Опубликовано:

5 авг 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 28

@annemarieplamondon5694 Месяц назад

I’ve been following you for quite a while now… And I now know why! Your explanations are so clear and concises! No frill, no bells and whistles just plain English and simple examples.Thank you so much Sumit for all the good work that ends up making us better.

@trumpexcel Месяц назад

Thank you so much for the kind words Anne 🙂

@charlesrodriguez2176 21 день назад

Great demo! FYI, you can also use the SORT function to add that layer.

@WekomVideos Месяц назад

Brilliant, this has given me an idea to streamline a recurring task to save time. Thank you so much, Sumit! 🤩🤩

@WekomVideos Месяц назад

And it worked!! I repeatedly need to remove all special characters from a long text string in a multiple cells and by using this formula I'm able to do it in a few clicks rather than removing each special character one by one using the Ctrl + H replace function. This is epic, thank you! =TEXTJOIN(" ",TRUE,TRIM(TEXTSPLIT(E2,{".",",","'","!","@","#","$","%","&","(",")",":",";","-","/","+"})))

@telugu-malayalamlearning8032 Месяц назад

Excellent Fantastic marvellous super

@rajeevgosavi4514 Месяц назад

Thanks for giving such a brilliant tip. Really useful. Could you also upload a video on how to remove duplicates within a cell using Power Query. Thanks.

@user-ky6lu8xx4z Месяц назад

thank you sumit for sharing valuable content.

@PaulEBrownbill Месяц назад

Thanks for the video, very useful

@RahulGupta-ig9gv 19 дней назад

Awesome trick

@Azhar_Khan383 Месяц назад

Awesome and amazing, Thanks Sir

@xeeshanahmad8757 Месяц назад

excellent 👍

@chakralamurali Месяц назад

Excellent sir

@rahulamesar5387 Месяц назад

Sir it will be great if you make some.case studies video on power query that could be used for most frequently done office work. Really love your work. Thanks

@hardiksolanki2295 23 дня назад

Thanks

@sauravnath83 Месяц назад

@Trump Excel can we also get the desired results by using Power Query

@celyb8384 Месяц назад

Thank you Sumit for this function, however if the sheet has 2000 rows with more than 4 different characters, is there an easy way to get the characters within the sheet? the formula will only apply if the specified characters are mention. Is there a default character that will represent the bunch of characters?

@hiteshk3007 17 дней назад

does this methos works with office 2019 without VBA code?

@rajeevgosavi4514 21 день назад

Sumitji, May I request you once again to please upload a video usingpower query method to remove duplicate from single cell.

@trumpexcel 21 день назад

Ok sure... let me try and figure out how to do this with PQ, and then will create a video about it. I already have the next two videos lined up, so will try and make this one after that.

@muhammadkausar2842 16 дней назад

Textsplit function is not available in excel below 2022

@payaljain5497 Месяц назад

Hi Sumit, if you could provide the excel file for this video please? That would be really helpful...Thanks in advance😊

@RudraEatingShow Месяц назад

First comment ❤❤

@soundaryasuresh1845 Месяц назад

Sir can't access dashboard excel file link sir

@muhammadfuadmulla6102 Месяц назад

Not showing this formula in excel 2021. Please give me suggest from your end. thank you

@trumpexcel Месяц назад

The formula I showed will work only if you have the new functions (I think all are available on Excel with M365 only). You can use the VBA method though which works in all the versions of Excel

@muhammadfuadmulla6102 Месяц назад

@@trumpexcel Thank you so much for giving suggest.