Скачать или смотреть Excel: Count Items in a Single-Cell Comma-Separated String (Requires 365)

In this Excel tutorial, I show you how to convert a column of text values into a single comma-separated string stored in a single cell. Additionally, you’ll discover how to count the number of items in that string using a simple formula. Whether you're working with large datasets or just looking for a more efficient way to manage your data, this step-by-step guide will streamline your process.

🗒 Notes and Resources
Download a copy of the file used in this video: https://share.zight.com/RBuRm1rg

Video: Excel: How to Count Unique Values Without Using a Pivot Table:    • Excel: How to Count Unique Values Without ...  

The formulas that I used in the demos:
=TEXTJOIN(", ",TRUE,UNIQUE(FILTER($B$2:$B$13,$C$2:$C$13=F2)))
=COUNTA(TEXTSPLIT(J2,", "))

✅ Want more FREE training?
Why not check out my other tutorials and/or subscribe to my newsletter, both of which can be done at https://theexceltrainer.co.uk

🙋‍♂️ Let's connect on social
Twitter:   / theexceltrainer  
Facebook:   / theexceltrainer  
LinkedIn:   / thomasmik  

#excel