How do you retrieve the Top 5 items of a category?

[djuunk]

For example, a product table has thousands of product numbers in the rows, but the unique product code distinguishes certain categories of the items by the third letter being A for Antennas, B for Brackets, C for Cones, and so on for dozens more, with numerous sizes and models available in each.

How can I organize the table (either by copying, creating new, or modifying the current) into nine or ten separate sub-tables showing the top 3 or top 5 models of the product that is in inventory?

 

[PaddyD]

Hi - welcome to the board.

I'd do the following:

1) Create a new column in your table that extracts the info you need from the product codes. Something like:

=mid(a1,3,1)

2) use this to drive a pivot table that does what you're after (show top n).

post back if you can't get it sorted.