Hello,
Please look at the following attachement. I am struggling finding how many unique products there is per customer? I have tried using pivot, but then I don't get the unique number. Maybe a formula can help me with this?
Kind Regards
JohnnyWalker
I think you should show us some sample result 1st, so we can write the formula.
-If the problem is solved, please mark your thread as Solved: Click Thread Tools above your first post, select "Mark your thread as Solved".
-Always upload a workbook before start your question
To attach a file, push the button with the paperclip (or scroll down to the Manage Attachments button), browse to the required file, and then push the Upload button.
+++ If my answer(s) helped you, please add me reputation by click on * +++
Please explain in details , as we are not getting . Then Attached the dummy file which is understandable.
Probably this lay out of a pivot table.
see the attached file.
Please reply.
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.
Hi,
Sorry if it wasn't clear enough. See the new attachement.
Customernumber 23 have 3 unique products.
Customernumber 56 have 2 unique products.
Customernumber 31 have 3 unique products.
Was this easier to understand?
Perhaps:
Put your criteria in A22, for example "34"
and put this in B22:
=SUM(IF(FREQUENCY(IF($A2:$A19=A22,MATCH($B2:$B19,$B2:$B19,0)),ROW($B2:$B19)-ROW(B2)+1),1))
Array Formula, when ENTER you need to press CTRL-SHIFT-ENTER button together, not ENTER alone
Pls find the attachment , and share your valuable feed back.
Last edited by jhabijay_10; 09-18-2014 at 04:17 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks