Dear Forum members,
In Sheet 1:
I have a list with customers (column A) with behind it the turnover within different product groups and the total turnover. Example:
excel1.png
In Sheet 2:
I managed to sort the data from sheet 1 to get a "top 4" list with customers based on its total turnover from highest to lowest. Example:
excel2.png
Required:
Now I want to know the 'Top 4' product groups which need to go behind the customers top 4 list. Example:
excel3.png
Hope someone is able to help me solving this issue. Thanks indvance.
Bookmarks