Hi, looked for forum to find answer for my question but didn't manage to find solution. I would like to find 5 top values from data, based on certain criteria. I also need way to present results, if there is a tie between 2 values, when status is same for both (for example companies: Foxtrot and India). I need to export the data from excel to some other softwares, so visual sorting isnt option. I think that the functions for: F3 and G3 are the most important (that's why i blurred the lats 3 columns of this example). I have tried the LARGE and SMALL functions, but my brains just explodes... Here is an example to descibre my problem in a case that Deal status is O: 1 2 3 4 5 6 7 8 9 10
This question generated 16 answers. To proceed to the answers, click here.
This thread is current as of Wed, 23 May 2018 02:58:00 EDT.
For more resources for Microsoft Excel:
This article includes the following tags:
- Microsoft Excel