A formula to list my top 50 highest items and their quantities

[tshepolt]

Hi guys I need a formula or a vba code to list my top items as per cell B2 (this is a manual entry) as per the attached file under TopItems (sheet), and they must be listed downwards from A5 & B5

[Sam Capricci]

so this is how I would do it, a couple helper columns. A rank formula to your usage sheet then a couple formulas to the top items sheet (see your attached sheet again.

[tshepolt]

Thanks it works but could you please write the formula for me, I just want to understand before "MATCH" at what cell range is it pulling from?

=INDEX(?????;MATCH(TopItems!D5;'Usage per Month'!$M$5:$M$41;0))
=INDEX(Table_Query_from_SysproCompanyA410[StockCode];MATCH(TopItems!D5;'Usage per Month'!$M$5:$M$41;0))

[Sam Capricci]

that index section is from A5:A41, when I selected it the formula inserted that table section. You must have made it a named table.
so without the table reference it would normally read =INDEX('usage per month'!$A$5:$A$41;MATCH(TopItems!D5;'Usage per Month'!$M$5:$M$41;0))

[tshepolt]

Oh I see thanks a lot, I'm already using the formula as we speak