Identify Duplicates and Non-Duplicates within an Array (Match)

Hi Brendan,

I have attached an example spreadsheet.

In column "C" I need the percentage from column "A" only for the first "Y" in each series.
As an alternative, counting the duplicate "Y" in each series, I can then use a simple formula to pull the correct percentages over to the next column.

In column "D", there are the examples of the percentages/non-duplicate indicators that I would need (it is alright for "N" to be counted).

Thank you again,

Jared