Review and rank items

johnstan

New Member
Joined
Jan 11, 2013
Messages
8
Hi, I am not sure if I am on the right Forum or this is even possible using Excel. Although I am not sure what power query or power pivot is I was wondering if they could be the tool for me?

I have a list of items that I have supplied and more often or not I supply other items as well to users.
I want to review any random item and have Excel list and rank other items that were supplied at the same time as the search criteria.

My train of thought is based on the Amazon idea of when someone buys something it suggest other items that were bought alongside the original.

Would this be better suited to Access? I am really looking to be pointed in the right direction before I waste too much time trying to achieve something that is not possible.

Thank you in advance for any help / suggestions you can give.

Regards
John
 

Excel Facts

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the $ sign).

Ozeroth

Active Member
Joined
Dec 14, 2013
Messages
264
Hi John,

Have a look at Basket Analysis on DAX Patterns:
Basket Analysis – DAX Patterns

specifically the section "Products More Likely Bought with Another Product"

Is this along the lines of what you are wanting to do?

Regards,
Owen
 
Last edited:
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,167,523
Messages
5,854,219
Members
431,627
Latest member
mantesh

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top