What's what I love about excel, there are many ways to do something. This is a very layman's approach but you know what, it does the job for 90% of people! I was looking for something that doesn't require sorting the data set but not gonna hate on this guy for keeping it simple!
Hi, unfortunately does not always work when u have massive data. I have over 20, 000 rows and tryin to figure out how many of those accounts are unique because accounts range from 1-20 rows.
wow. Yesterady I had a excel assessment and they asked how do we know if a customer bought more than once and I could have used this easy way. I didnt imaginee yhanks
If you want to be able to do this without sorting the information, you can write an if statement where you countif everything above the line you are checking for the same entry above (locking the top cell in the range but not the bottom)
Tedd - wonderful!! Thank U very much!! KISS = Keep It Simple Stupid. I've seen so many bad instructions on such a simple task - you nailed it. Thank you once again.
how do i count words from a list of phrases (each phrase has 3 to 5 words) and make a tally of each word ? I can't find it anywhere. i need a tutorial.
!!!!!!!!!!!!!!!!!!!Need so help plz!!!!!!!!!!!!!!!! I want to create a simple table with numbers from A1:A10. In cell B1 I want to type the number in, and have that number automatically enter in the table in cell A1. Than when i type the second number in cell B1, i want the number from A1 to drop to A2 and have the new number go on top "A1". I want to do this each time i type a new number in cell B1. How can i create this rule????
hi, sir good day, i have a problem, and i need your help, example in first hour in warehouse inventory one lot there is 32 apples and then next hour its 38, thus if i subtract its 6 and its correct, but what about if the quota is 40 maximum, then the next following hour its 39 and goes back to 5 so the total count is 6, but if i use subtraction the result is negative which is -34 which is wrong. I hope you can assist and help me with this. Thanks.
Hey Ted, thank you for the video. Aren't Anderson, SC and Anderson IL unique from one another. I think the way you did this suggests both andersons count as 1. Shouldn't Anderson, SC and Anderson IL be counted as two unique cities? This is my biggest problem is trying to figure out unique users when two people have the same last name.
Sir, how to count multiple columns value by choose particular text... Like ... Canara Bank ... Complete... Yes ...as like many Bank but choose complete .... Yes ...on link sheet ( summary sheet)
I realize you are only counting cities; however, some states have cities with same name, which is clear on your spreadsheet right after sorting. Can you please advise how you now count actual unique city/St?
would you pls show us how many times appear repeating words in excel column from below example. I mean how many cats or how many doors cat doors for interior doors cat doors for exterior doors cat door for window cat door stop cat door for sliding glass door cat doormat cat door for wall cat door toy cat door stopper cat doorstop
What's what I love about excel, there are many ways to do something. This is a very layman's approach but you know what, it does the job for 90% of people! I was looking for something that doesn't require sorting the data set but not gonna hate on this guy for keeping it simple!
OMG, I've been wanting to do for ages and it worked first time. Thank you so much
Thank you! This is much simpler than many other things I found & this worked great!
Thanks bro. You saved my life at work!
Amazingly simple. Thank you so much. Spent a good hour searching for the right way to do this and this video was the one that helped. Thanks.
You saved the day!!!!! Thank you
This helped me a lot. Thank you.
Thank you! Thank you! Thank you! You saved my life today!
Hi, unfortunately does not always work when u have massive data. I have over 20, 000 rows and tryin to figure out how many of those accounts are unique because accounts range from 1-20 rows.
wow. Yesterady I had a excel assessment and they asked how do we know if a customer bought more than once and I could have used this easy way. I didnt imaginee yhanks
Much Appriciated!
Now we have UNIQUE function in Excel
Thank you so much for this!
If you want to be able to do this without sorting the information, you can write an if statement where you countif everything above the line you are checking for the same entry above (locking the top cell in the range but not the bottom)
Thank you so much!
Thank you thank you thank you!!!! So helpful!
thanks for the help!!!!
Exactly what I was trying to do in excel today.Thanks muchly!
Thanks for making this process so EASY!
Helped me in my workplace thanks!!!
Thank you Mister
at 2:50 you selected also the 1st cell where you typed UNIQUE. So you will have every 10th or 11th cell without formula but typed UNIQUE.
Very helpful thank you
THANK YOU VERY MUCH....ITS BEEN A LONG TIME I'M FINDING OUT THE ANSWER FOR THIS MATTER ITS. EXACTLY WHAT IF LOOKING FOR
Ok Ted. What if you want to count unique values in a column sorted by another column?
Thanks exactly what Im looking for
Nice tip
Hi, what if I need to add additional information to that column, in which case, potential duplicate doesn't have to be just above?
Tedd - wonderful!! Thank U very much!! KISS = Keep It Simple Stupid. I've seen so many bad instructions on such a simple task - you nailed it. Thank you once again.
how would you do this on a non sorted list, isn't there just a way to assign value by searching the list without doing a sort?
how do i count words from a list of phrases (each phrase has 3 to 5 words) and make a tally of each word ? I can't find it anywhere. i need a tutorial.
Thank you! Worked very well for me.
What if you have null values inside city column?
Just a trivia interest. Do you want to count Anderson IL and SC as the same?
!!!!!!!!!!!!!!!!!!!Need so help plz!!!!!!!!!!!!!!!! I want to create a simple table with numbers from A1:A10. In cell B1 I want to type the number in, and have that number automatically enter in the table in cell A1. Than when i type the second number in cell B1, i want the number from A1 to drop to A2 and have the new number go on top "A1". I want to do this each time i type a new number in cell B1. How can i create this rule????
Thank you.................assignment sorted!!!!!!!!!!!!!!!!!!!!!!!
hi, sir good day, i have a problem, and i need your help, example in first hour in warehouse inventory one lot there is 32 apples and then next hour its 38, thus if i subtract its 6 and its correct, but what about if the quota is 40 maximum, then the next following hour its 39 and goes back to 5 so the total count is 6, but if i use subtraction the result is negative which is -34 which is wrong. I hope you can assist and help me with this. Thanks.
Hey Ted, thank you for the video. Aren't Anderson, SC and Anderson IL unique from one another. I think the way you did this suggests both andersons count as 1. Shouldn't Anderson, SC and Anderson IL be counted as two unique cities? This is my biggest problem is trying to figure out unique users when two people have the same last name.
How to use the unique count formula without sorting the data?
Sir, how to count multiple columns value by choose particular text...
Like ... Canara Bank ... Complete... Yes ...as like many Bank but choose complete .... Yes ...on link sheet ( summary sheet)
You're only comparing the City names, but in your data there's an Anderson, SC and Anderson IL.
How to calculate the number of entries of these unique entries in column G.
I realize you are only counting cities; however, some states have cities with same name, which is clear on your spreadsheet right after sorting. Can you please advise how you now count actual unique city/St?
use countifs & filter by state and then by city
I thought this was actually counting a "Unique" value (not duplicates), not calculating a duplicate value multiple times throughout a range. :(
Awesome!
It will not work if a Unique value is appearing more than 2 times
would you pls show us how many times appear repeating words in excel column from below example. I mean how many cats or how many doors
cat doors for interior doors
cat doors for exterior doors
cat door for window
cat door stop
cat door for sliding glass door
cat doormat
cat door for wall
cat door toy
cat door stopper
cat doorstop
thanks.
What if there were blanks?? Even blanks would get counted as unique.
if y change the sort orde, this formula didnt work anymore
Or u can use 'Remove Duplicate' under 'Data'
That was cool and does exactly what I was looking for in Excel, but I still prefer df.City.nunique() == len(df)
Thank you sir
Count manually and you will know your answer is wrong.
Thank u..
I guess this formula will not work if the order is like this?
Alexandria
Anderson
Atlanta
Alexandria
Anderson
Atlanta
Alexandria
Anderson
Atlanta
That's why he used the sort function first
Why not just click on remove duplicates?
because this video is to count unique value not for removing duplicates values
Totally wrong