Summarize data in Excel without VBA or dynamic table

Asked

Viewed 173 times

1

I’m sorry if this question has already been answered, but I’m not able to even elaborate the question to do the proper research.

I have a list of products sold in excel, and I need to select the three best-selling products on the list. Until then, I could use the "Major" function. The problem, is that the products can repeat in the list, I have no space to create dynamic tables, or use VBA in the spreadsheet.

Here is an example of the data:

    Produto | Vendido | QTT
    P1      |  1073,79|   21
    P2      |   553,72|   25
    P3      |   748,94|    6
    P4      |  1017,97|   13
    P1      |    98,98|    4
    P2      |   173,71|    9
    P3      |   189,98|    2
    P5      |   250,97|    3

I needed to put in a column, in the same spreadsheet, the products P1, P4 and P3, with their values.

That’s possible?

excel

  • Put an example of how your spreadsheet should look.

1 answer

1

Browser other questions tagged excel

You are not signed in. Login or sign up in order to post.