Viewer Q!🙋♂️ Remove Duplicates from a List in a Single Cell 🔥[EXCEL TIPS!]
ฝัง
- เผยแพร่เมื่อ 9 มิ.ย. 2023
- This is a no-audio/narration screen recording of how I used multiple functions in Microsoft Excel (MS 365) to remove duplicates from lists that appear in single cells. You can view the with-audio step by step tutorial here • Viewer Q! 🙋♂️ How to ...
💻 DOWNLOADS FOR PURCHASE
Zip Code Lookup Template [Excel] spotlightimpact.gumroad.com/l...
Square Carousel Template [PowerPoint] spotlightimpact.gumroad.com/l...
10 Minute Timer Slide Template [PowerPoint] spotlightimpact.gumroad.com/l...
Net Promoter Slider Chart Template [PowerPoint] spotlightimpact.gumroad.com/l...
Waffle Chart Template [Excel] spotlightimpact.gumroad.com/l...
Data Placemat or Dashboard Template [PowerPoint] spotlightimpact.gumroad.com/l...
🙏 SUPPORT MY CHANNEL
Subscribe to this channel for more tips, tricks, and tutorials! / @spotlightimpact
Join Spotlight Super Fans for early access to weekly tutorials / @spotlightimpact
Hit the THANKS button in any video!
Grab data design souvenirs from my shop on Gumroad spotlightimpact.gumroad.com/
Grab data design souvenirs from my Payhip shop payhip.com/spotlightimpact
Buy Spotlight Impact SWAG on Spring spotlightimpact.creator-sprin...
🎒 COURSES & TRAINING AFFILIATES
Depict Data Studio Courses depictdatastudio.teachable.co...
Excel University affiliate.excel-university.co...
Miss Excel (Opens monthly) links.miss-excel.com/exclusiv...
🙋FAQs
I’m using Microsoft 365 in my videos: PowerPoint, Excel, Word. If you don't have a feature you see here, check the Microsoft support pages for a version feature list
support.microsoft.com/en-us
Buying courses through affiliate links above costs no extra, but gives a small percentage of the proceeds to my channel.
#excel #exceltutorial #exceltips
Thank you for this, I did find one issue doing it this way: if you have data like "Blue" and "Blueberry", then "BLUE"berry will go under "Blue" column. My knowledge of Excel is still pretty basic however I found it easier to use =UNIQUE(C2:F2,TRUE) at the end of the list of duplicated data i.e column H2 and copy it down.
Oh excellent! Thanks for sharing! 🙏🏻
Do you know how to return only the unique value from the list in a single cell i.e from the column B1 if i want to return only Blueberry and Strawberry. is there any way to do it
Not sure would have to sit with it for a While. Maybe a countif function might help, or look up more on Index and Match functions.