[INDENT]Dear All,
I would need a formula to tell me that each customers I deal with what his most product type that he purchased. below is the list. Thanks & best regards.
[TABLE="class: cms_table"]
[tr][td]Customer
[/td][td]Product
[/td][/tr][tr][td]xyz
[/td][td]bags
[/td][/tr][tr][td]abc
[/td][td]shoes
[/td][/tr][tr][td]dfm
[/td][td]perfumes
[/td][/tr][tr][td]xyz
[/td][td]perfumes
[/td][/tr][tr][td]dfm
[/td][td]perfumes
[/td][/tr][tr][td]dfm
[/td][td]bags
[/td][/tr][tr][td]dfm
[/td][td]bags
[/td][/tr][tr][td]xyz
[/td][td]shoes
[/td][/tr][tr][td]abc
[/td][td]bags
[/td][/tr][tr][td]dfm
[/td][td]bags
[/td][/tr][tr][td]abc
[/td][td]shoes
[/td][/tr][tr][td]xyz
[/td][td]Wallets
[/td][/tr][tr][td]dfm
[/td][td]Wallets
[/td][/tr][tr][td]abc
[/td][td]Wallets
[/td][/tr][tr][td]xyz
[/td][td]bags
[/td][/tr][tr][td]xyz
[/td][td]perfumes
[/td][/tr][tr][td]dfm
[/td][td]Wallets
[/td][/tr][tr][td]xyz
[/td][td]Wallets
[/td][/tr][tr][td]xyz
[/td][td]bags
[/td][/tr][tr][td]abc
[/td][td]shoes
[/td][/tr][tr][td]dfm
[/td][td]Wallets
[/td][/tr][tr][td]xyz
[/td][td]perfumes
[/td][/tr][tr][td]abc
[/td][td]bags
[/td][/tr][tr][td]abc
[/td][td]shoes
[/td][/tr][tr][td]xyz
[/td][td]shoes
[/td][/tr][tr][td]xyz
[/td][td]bags
[/td][/tr][tr][td]xyz
[/td][td]Wallets
[/td][/tr][tr][td]dfm
[/td][td]Wallets
[/td][/tr][tr][td]dfm
[/td][td]bags
[/td][/tr][tr][td]dfm
[/td][td]bags
[/td][/tr][tr][td]abc
[/td][td]Wallets
[/td][/tr][tr][td]xyz
[/td][td]perfumes
[/td][/tr][tr][td]xyz
[/td][td]Wallets
[/td][/tr][tr][td]dfm
[/td][td]bags
[/td][/tr][tr][td]xyz
[/td][td]bags
[/td][/tr][tr][td]xyz
[/td][td]Wallets
[/td][/tr][tr][td]abc
[/td][td]perfumes
[/td][/tr][tr][td]dfm
[/td][td]perfumes
[/td][/tr][tr][td]xyz
[/td][td]Wallets
[/td][/tr][tr][td]abc
[/td][td]bags
[/td][/tr][tr][td]abc
[/td][td]bags
[/td][/tr][tr][td]dfm
[/td][td]Wallets
[/td][/tr][tr][td]xyz
[/td][td]Wallets
[/td][/tr][tr][td]abc
[/td][td]Wallets
[/td][/tr][tr][td]abc
[/td][td]perfumes
[/td][/tr][tr][td]xyz
[/td][td]perfumes
[/td][/tr][tr][td]xyz
[/td][td]Wallets
[/td][/tr][tr][td]xyz
[/td][td]bags
[/td][/tr][tr][td]dfm
[/td][td]shoes
[/td][/tr][tr][td]dfm
[/td][td]shoes
[/td][/tr][tr][td]dfm
[/td][td]shoes
[/td][/tr][tr][td]abc
[/td][td]bags
[/td][/tr][tr][td]xyz
[/td][td]Wallets
[/td][/tr][tr][td]xyz
[/td][td]bags
[/td][/tr][tr][td]dfm
[/td][td]perfumes
[/td][/tr][tr][td]xyz
[/td][td]Wallets
[/td][/tr][tr][td]xyz
[/td][td]bags
[/td][/tr][tr][td]abc
[/td][td]Wallets
[/td][/tr][tr][td]dfm
[/td][td]shoes
[/td][/tr][tr][td]xyz
[/td][td]shoes
[/td][/tr][tr][td]abc
[/td][td]shoes
[/td][/tr][tr][td]xyz
[/td][td]bags
[/td][/tr][tr][td]xyz
[/td][td]shoes
[/td][/tr][tr][td]xyz
[/td][td]perfumes
[/td][/tr][tr][td]dfm
[/td][td]Wallets
[/td][/tr][tr][td]dfm
[/td][td]perfumes
[/td][/tr][tr][td]dfm
[/td][td]Wallets
[/td][/tr][tr][td]abc
[/td][td]perfumes
[/td][/tr][tr][td][/td][td][/td][/tr][tr][td][/td][td][/td][/tr]
[/TABLE]
[/INDENT]