Hi,
I am trying to find out what formula i can use to obtain the top 3 items for each group, dynamically. Basically the top 3 items would automatically change based on a given criteria/filtered condition. Attached is what the data look like. The yellow box would be where the top 3 items would be displayed.
I keyed in what the results would look like for the first group (Group A) to give you an idea of what I am after.
Thanks for all your help.
Bookmarks