Hi All

I am doing some menu engineering in excel. I have a list of menu items in a column and the quantity sold in another. I need to get the top 3 and bottom 3 selling items. The problem arises when the quantities sold are some items. There could be a situation where the top 3 could be more than 3 if say for example 4 items have same quantities that are more than any other item. I have tried formulae like rank, large, index but no luck.

I would appreciate if you guys could help with this. Please let me know if you have any questions.

Thanks

PD