Formlula to return Y or N based percentage value

[bell_man]

Every four rows is the same account# column A, but column B the data is different and column C is also. Can anyone help with a formula to check the account number in Column F exists in column A and return in column G if all data in column C that match column A is 100 % Maybe return a Y or N or even 400% would work if they were added together. File uploaded for better explanation.

[XLent]

using your sample file:

F2: =IF($F2="","",IF(COUNTIFS($A$2:$A$1000,$F2,$C$2:$C$1000,1)=4,"Y","N"))

copied down

modify ranges to suit requirements.

[bell_man]

Thank you so much works great