how can i data mining in excel??

[smahdih]

hi every body

i have a excel file contain huge data that is about Customer buying behavior.
sample file attached.
i want find a relation between customer and products, for example a matrix like this:
2eurb4m.jpg
Book1.xlsx

1- how can i find what % of customers buys product #1, #2,....#i

I know how to work with VBA.

[shg]

Cross-posted at http://www.mrexcel.com/forum/excel-q...ing-excel.html