Sir Babydum GBE
01-16-2012, 10:08 AM
Hi
I have a purchase history log
Suppose in column A I have a list of 10 people and their names appear several times (1 row every for each product they order). So if Bob buys 10 oranges today, 5 apples tomorrow and 6 bananas next week. His name will appear 21 times on my sheet.
Peter might buy 3 bananas. So all in all - Peter's name is on the list 3 times. However, in column 2 is the list of fruit. So we have 10 oranges, 5 apples and 9 bananas
But want I want to do is return the following results next to each occurence of that persons name in column C:
Peter = 1
Bob = 3
Because Bob has bought 3 different types of fruit, Peter bought 1.
In actual fact its not fruit we're dealing with, its codes. So there may be thousands of customers and hundreds of different codes.
Any idea of what formula I need please?
BD
I have a purchase history log
Suppose in column A I have a list of 10 people and their names appear several times (1 row every for each product they order). So if Bob buys 10 oranges today, 5 apples tomorrow and 6 bananas next week. His name will appear 21 times on my sheet.
Peter might buy 3 bananas. So all in all - Peter's name is on the list 3 times. However, in column 2 is the list of fruit. So we have 10 oranges, 5 apples and 9 bananas
But want I want to do is return the following results next to each occurence of that persons name in column C:
Peter = 1
Bob = 3
Because Bob has bought 3 different types of fruit, Peter bought 1.
In actual fact its not fruit we're dealing with, its codes. So there may be thousands of customers and hundreds of different codes.
Any idea of what formula I need please?
BD