How to count duplicates in a list. Count the number of times an item appears in a list. Test for duplicates in a list. Check out my online courses
Let me teach you the VBA that I have learn in my five years of consulting
Become an Affiliate and earn 25% on Course Sales
For more help visit my website or email me at easyexcelanswers@gmail.com.
Contact me regarding customizing this template for your needs.
Click for online Excel Consulting
I am able to provide online help on your computer at a reasonable rate.
Check out my next one-hour Excel Webinar
I use a Blue condensor Microphone to record my videos, here is the link
Check out Crowdcast for creating your webinars
If you need to buy Office 2019 follow
I use Tube Buddy to help promote my videos
Check them out
Follow me on Facebook
TWEET THIS VIDEO
Follow me on twitter
easyexcelanswers
IG @barbhendersonconsulting
You can help and generate a translation to you own language
*this description may contain affiliate links. When you click them, I may receive a small commission at no extra cost to you. I only recommend products and services that I’ve used or have experience with.
Watch more new videos about Excel Office | Synthesized by Mindovermetal English
Thanks teacher good explanation makes it easier to understand
Outstanding excel tip, right to the point. Thank you so much Barb!!!
Love you Teacher 🥰🥰🥰🥰🥰🥰🥰🥰🤝🤝🤝🤝🤝🤝🤝🤗🤗🤗🤗🤗🤗
It does not work in my sheet, but the list is same as the one you showed.
This is awesome and straight to the point. Thanks Barb!
Nice
Thank you ^_^
This was very helpful, thank you and all the best.
Thank uh so much mam….
now how do i do this but not in the same sheet
Formula not working by me.
you're an angel
Great job . Great and compact explanation
OH ALLOH! THANKS FOR SHOW ME THE WAY FROM BARB HENDERSON!! Damn she's fucking true! This tutorial save my time! Plenty Thanks to You Barb!! I wish you get happy day all the time..
easy and quick, thank you
What nonsense make the screen close
Thanks for sharing this! So nice to get simple instructions that aren't prefaced with a backstory.
Very well very nice and thank you very much
Amazing. Thank you!
Many thanks. This has helped me massively.
You are amazing, I can just give you a hug 🙂
Thanks Barb, you saved my day 🙂
You should first create a copy of the list on a different column and then remove the duplicates from the new column. Once you’ve done that you can go back and use countif, with range being the primary list and item to check from the new list. Otherwise you’ll just show the same numbers again when counting duplicates.
Thanks a lot for very simple and straight forward teaching. this is what I was hunting for in you tube to learn and I am very happy I found it. thanks for your time and effort
Thanks a lot ..😊
this is very helpful, thank you so much!
This is the best Countif video …I have come across.
Nicely explained, do more
We cannot see what you are typing
Thank You Very Much this Helped me a lot.. 🥰
Thanks for your video.
Need to play new video for count formula as count a column:-
12
34
12
34
40
20
How many count exact in this column (34=2, 12=2, 40=1, 20=1; Total=6 but my need 34, 12, 40, 20=4 )
Me sirvió mucho, muy bien explicado, gracias.
you made that so easy. couple of cool tricks too. Thank you