Formula driven Summary table based on Criteria & sorted...

[Wardinho]

Hi,

I would like to create a summary table (in yellow) which lists products and sorts them by units sold (Big to small) based on the "sub-section" and week number specified in cells. Is this possible?

I have attached a raw data file for reference; this will be added to on a weekly basis by pasting below the existing data, so it will grow.

I am able to extract the data I want for one product or sub-section etc. but creating a list which is dynamic as I add more and more raw data has me stumped. Even if it never sorted by units sold it would be better than I have.

Thanks.

Create Summary Table.PNG

[AliGW]

Sorry, but I don't see the attempt you have made in the workbook - where shall I find it?

[Ace_XL]

This is an ideal situation for pivot tables with slicers. See attached.

formula-driven-summary-table-based-on-criteria-and-sorted-create-summary-table.xlsx

[Wardinho]

Yeah! that will work, thanks.

[AliGW]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.