Formula to extract top largest to smallest amount based on 3 criterias

Hi All,

I would like to list the top deals based on the largest expected bookings to the smallest based on a selection of 3 criterias, also this needs to consider duplicate ties. The criterias are the region, the architecture, and the quarter of the deal. As such, the result need to display the Arquitecture, the deal name and the expected booking amount. Find attached the file with the raw data.

Thank you all for your help.

Hi Benishiryo,

I will be great if this is done a different way without using arrays because the managers that will be using it are over 50 and will not want them to go through the crtl + shift + enter, if it does not work.

Thank you for your assitance.

Hi Benishiryo,

Your previous file worked wonderfully. Managers did not have any issues.

Just a little change. I just uploaded a new file with a new selection. In this case, the new field is ------ that will mean that regardless of the architecture, the arrays will need to list largest to smallest and everything else remaining the same.

Thank you very much.

Great job!!!

It works.

Aurisab