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
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!
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! 😂)
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.
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
@@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
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
@@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.
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.
You're a life saver. This kept me from counting 10,000 lines.
Super Thanks
Glad it helped!
I watched like 7 UA-cam's to try to get what you just did. It worked great, thanks!
Glad I could help!
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
Good tip!
Super quick. Super helpful. Thank you Barb for making just one moment of the day that little bit easier.
You are so welcome!
You are an angel Miss Henderson. Thank you for the clear explanation.
Glad it was helpful!
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!
You're very welcome!
Thank you so much Barb, you are a life saver. It was concise and comprehensive
You are so welcome
Hey Barb, this was so helpful I am leaving a comment! Thank you Smarty!!
You are so welcome!
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! 😂)
You are so welcome!
Thank you Barb, always such a great help. You explain and show examples that make us easily understand. Extremely grateful for your efforts.
you are very kind!
Incredibly helpful video! Thank you.
Glad it was helpful!
Thank you so much for this. I needed to do the numbering of the duplicates and this was really helpful!
Glad it was helpful!
Thanks Barb! Just was I was after 😊
happy to help
thank you so much!! your teaching is straight forward and efficient!! you saved my job haha
Happy to help
Thank you - this was exactly what I needed and easy to follow!
Great to hear!
Thank you for your kind to share the trick that useful :D
I am happy that it worked for you!
This was super helpful. Thank you.🙏🏽
You're so welcome!
Nice, clear explanation. Worked for me!
thank you
Very useful. Thank you so much
You are welcome!
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.
good idea!
OMG A LIFE SAVER, TAHKYOU!
Happy to help
EXACTLY what i was looking for! thanksss
Glad I could help!
You’re the absolute best omg
thanks
Thank you Barb.
Welcome!
you`re the queen!
Thank you for watching
Cheers Barb u legend
thanks!
Useful Video, thanks.
So nice of you
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
If you are trying to count unique it would be one!
@@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
Genius! Thanks
thanks
Thank you 🙏 just used it
happy to help
Thanks Barb
Welcome!
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
That is interesting!
Thanks, that was great!
Glad you liked it!
Great explanation
Glad you liked it
what kind of sorcery is this? thanks a lot.
Just a good trick! thanks
Helpful, thanks!
You're welcome!
THANK YOU
Welcome
Wow very helpful
Glad it helped
Thanks for the video. How can i count the number of each duplicate by month? or other criteria?
you would have to filter by the other criteria first
You are wonderful
thanks
Thank you
You're welcome
Very helpful
Happy to help
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.
You could try putting 120 in a cell and referencing that in a formula rather than typing in the 120
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.
they have to be numerical
Awesome!
Thanks
You bet!
Thank you so much
You're most welcome
wow amazing thnx
Most welcome 😊
Excellent
Thank you so much 😀
THANK YOU!!!!
You're welcome!
Why not enter =UNIQUE(A2:A9056) and then perform a COUNTIF on those results?
that works but so does this!
can you teach me with vba code? thank you
you can use worksheet functions in VBA by placing "Application.WorksheetFunction" in front of commands
thanks!
Welcome!
Thank u
Welcome
life saver
happy to help!
doing exactly the same thing yet it says to me "are you not trying to create a formula"? -_-
did you put an equal sign (=) in front?
@@BarbHendersonconsulting of course
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"
why make a pivot table when you can do it this way?
More time, more steps, less flexibility, less analysis capabilities. Just to name a few. @@BarbHendersonconsulting
@@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.
Greate
thanks
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.
Good for you but people are looking for a non-maco solution to their problems
@@BarbHendersonconsulting How do you know what people want, Magician?
no, but I have twenty years experience with dealing with customers@@CzMnHD
Exactly what I was looking for, thanks so much
Glad I could help!
Super helpful
Thanks a lot
Happy to help
Thank you
Welcome!