Most valuable professional
  • Hot Topics

Excel 5 highest values with multiple criterias and possible tie

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:

  • Excel
  • Microsoft Excel