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||Value||Company||Status||Deals Open||Deals Lost|
This question generated 16 answers. To proceed to the answers, click here.
This thread is current as of May 23, 2018.