This is fantastic and explained well in just 20 seconds. I have been searching for this solution for 4 days! Thank you very much... I really appreciate you
The UNIQUE is good, but the COUNTIF could be much better. Here's what I'd do: =COUNTIF(A$2:A$25, B2#) You need to do the $ to make at least the rows absolute references. Even better, use the # sign after B2, that way it will always spill to be the exact length of the UNIQUE. That way if you add a new name, the COUNTIF will go down the extra line.
You can make it more dynamic if you use B2# instead of just B2 and dragging the formula down. If you're already using a dynamic array formula UNIQUEUE() you might as well use the dynamic array references.
From an Excel novice, could someone please explain the last super-quick piece of advice: "drag it down and then done"? Am I supposed to be holding a key while dragging in order to repeat the formula for each cell in column B? Just a simple drag merely highlights the cells.
This is fantastic and explained well in just 20 seconds. I have been searching for this solution for 4 days!
Thank you very much...
I really appreciate you
Thank you!
Guess when u drag it, the cell references changes. Please lock the range cells and drag to get correct results
Women !
@@dipsaha591 Screw you. Why do you assume a woman would be any less capable with software???
how do you do this?
@@JayCapoF4
This is literally the function I was looking for at work today. You’ve just made my life so much easier. Thank you!!!
@@masonbeck566 thanks!
I had to use this for 5,000 queries, super thanks! this is really helpful!
Glad to know it helpful for you!
a sincere thank you for this!
Thank you SO MUCH for this! You've saved me a ton of work.
Thank you, It worked beautifully 💖
THANK YOU!!! I have been struggling to figure this out...
Happy it helped!
Thank you so very much we need these videos thank you ma'am
I’m happy they are helpful
@@XecuteTheVision you are amazing believe me before I start watching your videos usually I like first thank you so very much 🌹🎩
💛
Very useful, thank you
You’re welcome 😀
This vedio came in its time.
Thanks a lot.
You’re welcome
THANK YOU!
The UNIQUE is good, but the COUNTIF could be much better. Here's what I'd do: =COUNTIF(A$2:A$25, B2#) You need to do the $ to make at least the rows absolute references. Even better, use the # sign after B2, that way it will always spill to be the exact length of the UNIQUE. That way if you add a new name, the COUNTIF will go down the extra line.
Thanks for the tip!
This formula using for lot of cell numbers data also pls gv rply
very nice.
I love you, thank you.
Best 💯❤👍👊🙏
Very use full tq mam
Thank you
=CountIfs($A$2:A2,A2)
Yes, well done
I use pivot
Thankyou ❤
You’re welcome!
Life saver
Using of pivot table is best for it
You can make it more dynamic if you use B2# instead of just B2 and dragging the formula down.
If you're already using a dynamic array formula UNIQUEUE() you might as well use the dynamic array references.
👏
I prefer to do this with pivot tables
Good but I would combine the forulas in one
use spill function, it will give better results
great
Thank you
From an Excel novice, could someone please explain the last super-quick piece of advice: "drag it down and then done"? Am I supposed to be holding a key while dragging in order to repeat the formula for each cell in column B? Just a simple drag merely highlights the cells.
Got it! I wasn't dragging on the plus sign in the corner of the cell.
Sum product and len I use
Use Traditional method
1 Table
2 Pivot table
3 Early lunch
🤣
Did you forget to press F4
May Wanna make the range fixed
you didnt lock down the range
As everyone is saying you need to lock the first range in the countif. Your tip is technically wrong
Thank you
I'll take things I would Google if I ever needed to know for 100.
😂
It seems like you skip some things
I am not finding unique formula in Excel wh?y
It is likely a version issue
You dont need list you can count it without creating a list
yeah much quicker
But it not work 2019 sheet
U don’t need to create column B
Unique not present in my Excel
UNIQUE function not showing in list
S/5,M/5,L/5= HOW CAN I PLUS THIS FORM
S/5,M/5,L/5=?
Can you get a better microphone? Your voice is very echoey. It’s a bit hard to parse for people with sensitive hearing. Thanks.
Thank you for feedback
Nice trick ...subbed
Thank you
Didn't fix cell references
This need a slow video
This is not how a pro does it. 😂