How can I get the top x products of each brand in Google Sheets?-CodePudding

Home > database > How can I get the top x products of each brand in Google Sheets?

How can I get the top x products of each brand in Google Sheets?

Time：12-06

I have a Google Spreadsheet that retrieves product data containing the SKU, Name of the product, the revenue in the past x days. Using a Regexmatch function I retrieve the brands from the products that will be in sale the coming weeks.

Now I want to retrieve the top 5 products of each brand (based on highest revenue) and if I use the Query function I am not able to get the limit per brand sorted. How can I do this? Hereby an example of the dataset:

Page link：https//www.codepudding.com/database/632862.html

Prev:Trying to remove all text within Parentheses and remove parentheses as well as well as Turn all the

Next:How can I identify the same character found in 2 Strings in Excel?

Tags：

google-sheets

Links：
CodePudding