Hi,
I have been searching for this and cannot find a solution if anybody can help.
So I have two columns "usernames" and "products". The list shows specific transactions, meaning user and product paid by him or her. So there are duplicate values in both columns since each user paid multiple products for the specific time period. (I have 12,000 unique users, 350 products and about 200,000 transactions).
I need to get a largest to smallest list of users by paid unique products, meaning I need to return unique values from the products column for each user.
The only way I came up with so far is to filter for each individual user and then use remove duplicates for the products column, which is impossible to do 12,000 times.
Can anybody help?
Bookmarks