I want to count items in a list in excel but I don't want repeated values to be counted twice, what can I do? Please help!
I want to count items in a list in excel but I don't want repeated values to be counted twice, what can I do? Please help!
=SUM(IF(COUNTIF(range, range)=1,1,0))
CTRL+SHIFT+ENTER.
It's not working :(
Thank you though :)
it's giving me an erroneous answer. I know that because I used the =unique()function to show the values that don't repeat over the list and then counted those values.
This is what i want to achieve:
I have a list of people but that list has some repeated names, so I want to count how many people I have on that list without counting the repeated ones.
Administrative note
Welcome to the forum
in your haste to solve your problem, you probably missed the yellow banner advising how to get answers faster by posting a sheet ?
Please take a moment to read it and attach a sheet accordingly.
Thanks you for helping us help you
=SUMPRODUCT(1/COUNTIF(A1:A10,A1:A10))
change A1:A10 to your data range
How do I count the number of items in a cell separated by commas i.e. cell A1 (goat, sheep, deer) and cell B1 is 3 the COUNT/number of items in cell A separated by comma, thank you . . .
A B
1 goat, sheep, deer 3
Did you try a pivot table?
Willem
English is not my native language sorry for errors
Please correct me if I'm completely wrong
@ rengeroni
Administrative Note:
Welcome to the forum.
We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original.
Please see Forum Rule #4 about hijacking and start a new thread for your query.
If you are not familiar with how to start a new thread see the FAQ: How to start a new thread
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks