a formula that will return the largest count of product brought by each customer

[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]

Re: a formula that will return the largest count of product brought by each customer

difficult question to answer

Re: a formula that will return the largest count of product brought by each customer

Quote from jindon;692644

VBA sample.
Just ignore if you don't like it.

Jindon,

Super Bravo. You did it correct man and I like it alot.

Thank you so much