Hi,

I am new here but fairly good with most of the excel formulas. However, I have been completely stumped by this this particular problem with one of my reports.

I am trying to put together a product upselling report which advices a rep to upsell another product if the customer has already purchased one of the items. I am looking at a sample historic data sheet attached below (it is not real data and the names of products have been changed).

- What I am trying to find is how many times a product pairing has occurred i.e. how many times a customer has purchased pears and oranges; or water bottles and tea, etc.
- From the product pairing which product has been yielded more in $$.


Sample Excel Help File.xls

What I am looking to do:
Product Purchased Prod Suggest 1 Prod Suggest 2 Prod Suggest 3
Blades
CD Case
Grapes
Oranges
Paper
Pears
Ramen Noodles
Tea
Tennis Balls
Water Bottles



Example:

CUST ID Product Revadj
CXXCXX98 Tea 1,717.34
CXXCXX98 Oranges 18,533.42
CXXCXX98 Pears 1,104.01
CXX00144 Tea 58,570.91
CXX00144 Tea 6,474.24
CXX00144 Tea 6,155.44
CXX00144 Water Bottles 96,696.88
CXX00144 Tennis Balls 4,465.92
CXX00144 CD Case 62,983.87
CXX00144 Grapes 98.41
CXX00144 Grapes 21,106.3
CXX00144 Grapes 565.62
CXX00144 Pears 3,117.9
CXX00144 Pears 1,246.08
CXX00144 Pears 48,388.16

I am pretty new so I am putting this in the Excel Formulas & Functions threat because I think there is a way to do this without having vba hat on.

Please help.

Thanks in advance.