Large function with if criteria

Thank you very much.

A follow-on question: if i need to return unique values, how would one modify the formula?

Example:

Dept. Name / Widgets
ABC / 10
ABC / 8
XYZ / 9
ABC 7
ABC 7
ABC / 3
XYZ / 4

Based on the formula you provided, the third largest value for Dept ABC will be 7. However, if I extend it to the fourth largest value, the formula will also return 7.

hello,

I attached a spreadsheet showing a simplistic example of my data set.

The objective is to to sum up the Shares Authorized for a give Stock Ticker based on the unique Ticket #. For example, GE will have a aggregate Shares Authorized of 5 million shares (1 million from Ticket #2, 2 million from Ticket #7 and 2 million from Ticket #12). For MSFT, there will be 6 million of Shares Authorized (1 million from Ticket #1 and 5 million frm Ticket #6).

How would I do this in excel? Many thanks in advance.

Thank you.