arrays, unique values and sorting

[maks25]

Hi,

I am trying to create an array that would return unique tickers from column A, aggregate all the values (from column B) for each unique ticker and then sort the new unique table from largest to smallest.

I have attached an excel file.

I have been able to accomplish everything but the sorting.

If you have any ideas on how to accomplish this please let me know.

Thanks