Hi all,
Im looking for a way to return the top 5 selling items into another table.
I need a formula or way to recognize the highest value in column i and return it along with the product code from column a into the table on the bottom right of my example sheet attached.
The main table (columns a to col j) changes as the supplier changes, so the data depending on the supplier can be anywhere from 3 line items or rows to 50 with numerous suppliers.
So therefore i dont want to have to do it manually each time.
Hope this makes sense.
Thanks in advance.
Rob.
Bookmarks