Count the number of each duplicate in Excel

[@EvanSarris]

Just a quick tip. After hitting CNTRL SHIFT DOWN ARROW to highlight the range, Use CNTRL BACKSPACE to get back up to the top to continue your formula. Thanks for the video

[@BarbHendersonconsulting]

Good tip!

[@______NoMaD_______]

You're a life saver. This kept me from counting 10,000 lines. Super Thanks

[@BarbHendersonconsulting]

Glad it helped!

[@foomanwho7294]

Super quick. Super helpful. Thank you Barb for making just one moment of the day that little bit easier.

[@BarbHendersonconsulting]

You are so welcome!

[@cracheoverride9006]

Thank you Barb, always such a great help. You explain and show examples that make us easily understand. Extremely grateful for your efforts.

[@BarbHendersonconsulting]

you are very kind!

[@adamfisher4239]

Excellent instructional video. I can tell by the number of comments below that it helped boost productivity for a number of us and helped us learn a new skill at the same time. Thanks for YOUR time in putting this together!

[@BarbHendersonconsulting]

You're very welcome!

[@katrinzahnweh]

Wow. Pretty complicated stuff - clearly explained. Thank you, Barb! 🥰 To be honest, I even did not know the fill-function yet - I always did that much more complicated (copy cell, jump to the bottom, mark the according column and paste the cell... OMG - it can be so easy! 😂)

[@BarbHendersonconsulting]

You are so welcome!

[@erecuper1967]

Hey Barb, this was so helpful I am leaving a comment! Thank you Smarty!!

[@BarbHendersonconsulting]

You are so welcome!

[@tiriconnell9200]

Thank you so much for this. I needed to do the numbering of the duplicates and this was really helpful!

[@BarbHendersonconsulting]

Glad it was helpful!

[@AjaeWallace-r8y]

Thank you - this was exactly what I needed and easy to follow!

[@BarbHendersonconsulting]

Great to hear!

[@ninninbaby]

thank you so much!! your teaching is straight forward and efficient!! you saved my job haha

[@BarbHendersonconsulting]

Happy to help

[@ca91101]

Incredibly helpful video! Thank you.

[@BarbHendersonconsulting]

Glad it was helpful!

[@stevenmu73]

I saw your video today. And I actually copied the list then paste it in a different column then removed the duplicates from there, then I referenced the original list and used the new column as the criteria and boom you will have each # once and know how many times it has came up in the original list.

[@BarbHendersonconsulting]

good idea!

[@matsturmey]

Thanks Barb! Just was I was after 😊

[@BarbHendersonconsulting]

happy to help

[@tpolakis]

Nice, clear explanation. Worked for me!

[@BarbHendersonconsulting]

thank you

[@UMEEKable]

EXACTLY what i was looking for! thanksss

[@BarbHendersonconsulting]

Glad I could help!

[@quintonngai8670]

Thanks for the video. How can i count the number of each duplicate by month? or other criteria?

[@BarbHendersonconsulting]

you would have to filter by the other criteria first

[@Aardey]

Very useful. Thank you so much

[@BarbHendersonconsulting]

You are welcome!

[@kovek9090]

Thank you Barb.

[@BarbHendersonconsulting]

Welcome!

[@Iamshomarid]

You’re the absolute best omg

[@BarbHendersonconsulting]

thanks

[@j.p.adithyakumar2223]

Useful Video, thanks.

[@BarbHendersonconsulting]

So nice of you

[@89desirae]

Can this be done for numbers that are in any order or does this formula only work if the digits are exactly the same? Ex: 1234, 3412.

[@BarbHendersonconsulting]

they have to be numerical

[@connor9899]

Cheers Barb u legend

[@BarbHendersonconsulting]

thanks!

[@moesadr3342]

Can someone please explan how we also can the get the number of repeats for each unique value? Similar to Countif to ge the total number of each value within a coulumn? Let's say the first coulmn shows the Exact Unique Values and the second column shows the number of existing Unique Values next to its name. Thank you

[@BarbHendersonconsulting]

If you are trying to count unique it would be one!

[@Franoo-uknow]

⁠​⁠@@BarbHendersonconsultinghi Barb! I am looking to use this formula, but create one returned value only (same as this comment above). What exactly would the formula be? I am unsure how to include this aspect into your original formula. Thanks in advance

[@mimasv]

you`re the queen!

[@BarbHendersonconsulting]

Thank you for watching

[@stlacu]

Thanks, that was great!

[@BarbHendersonconsulting]

Glad you liked it!

[@rajeshnm8202]

Thank you 🙏 just used it

[@BarbHendersonconsulting]

happy to help

[@mohammadyounas5495]

if we apply formula and we type manual numbers its warning as double entry. but if we copy past same number its showing double and now warning for double entry

[@BarbHendersonconsulting]

That is interesting!

[@rishimakan]

Thanks Barb

[@BarbHendersonconsulting]

Welcome!

[@d-katsu8931]

Great explanation

[@BarbHendersonconsulting]

Glad you liked it

[@laxmanbiotech]

my list has 120, 1120, 3210. When i use countif for 120, it says 3 ( taking the other two as well). any solution for this please.

[@BarbHendersonconsulting]

You could try putting 120 in a cell and referencing that in a formula rather than typing in the 120

[@johnh6696]

Helpful, thanks!

[@BarbHendersonconsulting]

You're welcome!

[@encore724]

what kind of sorcery is this? thanks a lot.

[@BarbHendersonconsulting]

Just a good trick! thanks

[@MEGASkillz92]

Genius! Thanks

[@BarbHendersonconsulting]

thanks

[@arunkumar-ws1pk]

Wow very helpful

[@BarbHendersonconsulting]

Glad it helped

[@nikkim9712]

You are wonderful

[@BarbHendersonconsulting]

thanks

[@abbottkatz8830]

Why not enter =UNIQUE(A2:A9056) and then perform a COUNTIF on those results?

[@BarbHendersonconsulting]

that works but so does this!

[@abulkarim6084]

Awesome! Thanks

[@BarbHendersonconsulting]

You bet!

[@gugushange2964]

Thank you so much

[@BarbHendersonconsulting]

You're most welcome

[@7Kris07]

Very helpful

[@BarbHendersonconsulting]

Happy to help

[@SurekaBalachander]

THANK YOU

[@BarbHendersonconsulting]

Welcome

[@mohantamangktm]

wow amazing thnx

[@BarbHendersonconsulting]

Most welcome 😊

[@kappasontv]

THANK YOU!!!!

[@BarbHendersonconsulting]

You're welcome!

[@jamesdep8128]

Excellent

[@BarbHendersonconsulting]

Thank you so much 😀

[@sultanabukhas]

Thank you

[@BarbHendersonconsulting]

You're welcome

[@hipernet]

thanks!

[@BarbHendersonconsulting]

Welcome!

[@samnangsuonsokunth8719]

can you teach me with vba code? thank you

[@BarbHendersonconsulting]

you can use worksheet functions in VBA by placing "Application.WorksheetFunction" in front of commands

[@MohammedAli-g2b9p]

life saver

[@BarbHendersonconsulting]

happy to help!

[@bipulkumar2784]

Thank u

[@BarbHendersonconsulting]

Welcome

[@RahsaanDean]

Kind of a weird way of doing this. Just create a pivot table and put whateverr you want to tally in the values area and choose "count of"

[@BarbHendersonconsulting]

why make a pivot table when you can do it this way?

[@RahsaanDean]

More time, more steps, less flexibility, less analysis capabilities. Just to name a few. @@BarbHendersonconsulting

[@funnyperson4016]

@@BarbHendersonconsultingcool. Yeah both ways work pivot tables are done automatically and is a way to clean up the list so you only have one of each number plus the count next to it. Put account in “rows” and also “values” and select “count of” and then you can sort how you want and copy it wherever you need it. If you don’t want to mess with the original data but you want a kind of summary or something you may want pivot tables. If you want to have data with a reference for each data point your way works best. Otherwise it’s preference.

[@dominikdominik1139]

doing exactly the same thing yet it says to me "are you not trying to create a formula"? -_-

[@BarbHendersonconsulting]

did you put an equal sign (=) in front?

[@dominikdominik1139]

@@BarbHendersonconsulting of course

[@tusharpawar6088]

Greate

[@BarbHendersonconsulting]

thanks

[@CzMnHD]

This counting process takes too many click and thinking. Its way easier to watch auto macro videos, I could do this whole process with 5 second macro record and press play button and it moves all my data even to the other system that wants this data. Allways use macros before you start Math calculations to save any unneccesary clicks with mouse and waste time on your computer + eyes.

[@BarbHendersonconsulting]

Good for you but people are looking for a non-maco solution to their problems

[@CzMnHD]

@@BarbHendersonconsulting How do you know what people want, Magician?

[@BarbHendersonconsulting]

no, but I have twenty years experience with dealing with customers@@CzMnHD

[@davidareeves]

Exactly what I was looking for, thanks so much

[@BarbHendersonconsulting]

Glad I could help!

[@balachandrikathottempudi1987]

Super helpful Thanks a lot

[@BarbHendersonconsulting]

Happy to help