I have used Counta for either numbers or text columns for years. I use Count only in conjuctiin with number cleaning by comparing Count and Counta to help find erroneous formating of numbers/text especially in very large data sets. The list of zip codes is Distinct but not Unique. The UNIQUE function will generate either s Distinct list (default) or a Unique list (by selecting the "occurs only once" argument).
@@ChrisMenardTraining i didnt doubt that you new the difference and you do a great job explaining it in that older video. However I am frustrated that the vast majority of Excel users do not recognize the difference. If they toss their data set into the Data Model they will find Distinct Count in the drop-down of built-in calculations. Manages will ask for unique lists when they want distinct lists. I don't consider it picky and it certainly isn't an advanced topic!. Then you could ditch the non-term "true (or "truly") unique!
![[DRIP] ‘CLIK CLAK’ PREVIEW](http://i.ytimg.com/vi/bcxkcOSbpac/mqdefault.jpg)
Blog post chrismenardtraining.com/post/excel-combine-the-sort-unique-and-count-functions
Thnx Chris……haven’t seen the sort function before….always learn something new from your posts 🙏
Thanks, Jeff.
Hi Chris, thanks for the video. How can you count the total filtered unique characters excluding the hidden cells in a column?
Great video and great explanation 👍
Thanks 👍
I have used Counta for either numbers or text columns for years. I use Count only in conjuctiin with number cleaning by comparing Count and Counta to help find erroneous formating of numbers/text especially in very large data sets.
The list of zip codes is Distinct but not Unique. The UNIQUE function will generate either s Distinct list (default) or a Unique list (by selecting the "occurs only once" argument).
True. I didn't feel like going into it in this video, but I covered it here th-cam.com/video/P5QQPvDeFoo/w-d-xo.html Thanks, Richard!
@@ChrisMenardTraining i didnt doubt that you new the difference and you do a great job explaining it in that older video. However I am frustrated that the vast majority of Excel users do not recognize the difference. If they toss their data set into the Data Model they will find Distinct Count in the drop-down of built-in calculations. Manages will ask for unique lists when they want distinct lists. I don't consider it picky and it certainly isn't an advanced topic!. Then you could ditch the non-term "true (or "truly") unique!
I have a material list and I would like to know how to count each item in each page to get me a total for each item.
Do you have any videos for vlookup or hlookup? I need to do some data cleaning and text transformation
I do, but I would use the XLOOKUP which came out a couple of years ago. Here is a video I created th-cam.com/video/1sSje27jnTA/w-d-xo.html
@@ChrisMenardTraining This is great, thank you!