Need a VBA script for excel

Hi,
 
I have 3 columns in excel
 
Order # is unique
 
Order #             Customer #                      Product#
hdf0898            1335                                 3695
ffdsf5656           1335                                 3695
 
I have 1000's of rows for different products
I would like to find whether the same customer has bought the same product more than once if there a duplicate and i want that rows to be highlighted. if you have more suggestions to find how many times, it will be more helpful.
 
Thanks in advance

So here is how I would do this if it were my problem to solve:
 
Make a dictionary where the key is the customer id and the value is another dictionary. The second dictionary would have the key be a product ID and the value would be the number of times the customer had ordered that product. Here are some search terms to get you started:
 
WScript.Dictionary
Excel.Application

http://blogs.techrepublic.com.com/msoffice/?p=842
 
 

My suggestion doesn't use VB or VBA, but rather a built in Excel capability...
 
I would simply establish a filter on the header row and then filter on the customer ID, sorting by Product number.
The built-in Total, Average and other functions still work in this mode as do the charting functions.