Return specific value that applies to duplicate references

I am looking to perform a function in Excel, I assume it will need a string of IF/ Lookup formulae. In the attached spreadsheet I have a list of unique references in column B which are all related to the section references in column A. In column C I have an identifier which indicates if the value in column B is true or not.

What I need is an easy way of identifying if a single reference in column A contains any unique references in column B which have a 'Yes' indicated in column C. If they are all 'No' then the reference in column A can be treated as 'No', if there are one or multiple 'Yeses' in column C like in the attached example then the reference in column A can be treated as 'Yes'.

Apologies if the title doesn't summarise what I need but I didn't know how else to word it.

Hopefully someone can help - many thanks!

one option:

D2:
=IF($A2=$A1,D1,IF(COUNTIFS(Table1[SectionReference],Table1[@SectionReference],Table1[IsBlock],"Yes"),"Yes","No"))
copied down