How do I set a countif but dont want to count duplicate names? Example a sales team of 5 sold x number of iteams but then Adams name may come up several times due to mutiple things sold. I just want the countif to count name once?
Thanks,
How do I set a countif but dont want to count duplicate names? Example a sales team of 5 sold x number of iteams but then Adams name may come up several times due to mutiple things sold. I just want the countif to count name once?
Thanks,
with a pivot table like in the similar below question
https://www.excelforum.com/excel-gen...-criteria.html
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
So one category is the name the other what he sold , I want countif not to count the duplicate names
Hi Noah,
If you can supply a sample workbook, it is much easier to supply a formula. Formulas are based on which row or column and how the data is arranged.
Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.
Remember to desensitize the data.
Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
Sorry having some issues in upload I'll give you an example
Raw data
Colomn A (iteam sold) Colomn B (name)
1 Ford Mustang David
2. Ford Mustang. David
3. Jeep Cherokee Kevin
4. Audi Q5. Kevin
5 Audi Q5 John
6. BMW X3 John
7. Bmw X1 Priya
8, Audi Q5 Jaspreet
Front Dashboard (structured data) formulas will be here
Col A. Col B will have the formula
Bmw 2
Audi 3
Jeep 1
Ford Mustang 1
Like the above,the countif will do that
Hope that helps,
Thanks!
Last edited by Noah101; 09-10-2017 at 05:52 PM.
- click Go Advanced,
- scroll down until you see Manage Attachments,
- click that and select Browse,
- select your file and click Open,
- click Upload and you will see your attachment below Upload Files from a website
- click Close this window,
- click Submit reply
After that you should see attachment in your post
I can't I'm sorry I know these steps, my pc doesnt let me.
Ok, you can try with PowerQuery
Is that what you want?
(sorry but no formula(s) )
Last edited by sandy666; 09-10-2017 at 06:20 PM.
With A1:B8 is data
A10 is car name
B10 is name
B10:
=SUMPRODUCT(($A$1:$A$8=A10)/COUNTIFS($A$1:$A$8,$A$1:$A$8,$B$1:$B$8,$B$1:$B$8))
Ctrl-shift-enter
Quang PT
In the link I offered in #2, there is a formula solution in #5.
In #11 the OP has comment it is working on his situation (which is simular to yours).
Can you explain why you did not take the time to look at that question (in my link)?
its now solved, thanks everyone! yes I read it but I went thought it a little too fast. My apologies,
Thank you!
Noah
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks