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:

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

I know how to work with VBA.

http://speedy.sh/3G92u/Book1.xlsx

 

[Andrew Poulsom]

You need to make a list of customer codes and product codes, repeating the customer code against each product. Then you can create a pivot table with product code in the row area and count of customer code in the data area. For a quick way to repeat the customer code in each row see:

http://www.contextures.com/xlDataEntry02.html#fill2007

After filling you need to delete the rows with blanks in column B.

 

[arthurbr]

Cross post how can i data mining in excel??

 

[smahdih]

hi every body
Nice to see you agian

here i have a excel file, i want basket analysis, in "basket Code" Column in have about 550 basket and every basket contain some product,
when i click on "Process" button calculation start.
how can i optimum this code for decrease running time?

if i must learn heuristic algorithm , Please note me

analysis.xlsm - Speedy Share - upload your files here

 

[smahdih]

UP...