Sorry if this question has already been answered, but I'm not even getting the question to do the proper search.
I have a list of products sold in excel, and I need to select the top three products on the list. Until then, you could use the "Major" function. The problem is that the products can be repeated in the list, I do not have room to create PivotTables, or use VBA in the worksheet.
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 the products P1, P4, and P3 in a column on the same worksheet, with their values.
Is this possible?