Can anyone help me with this one.

Column A holds customer numbers, they can have multiple products so they may be on more than one row.
Column C holds a Y/N as to whether they have the product

I need to compare all entries for one customer number and return an answer so that if a Y appears the Y wins, if no Y, it brings back N.

965050551 Global 150 N
965050551 Global Other N
965340778 Global AFF Y
965340778 Global INV N

So in the scenario above customer 965050551 would return N but 965340778 would return Y.

It would be a look up of all entries under one number, looking at all answers in Column C and returning a unique value.

Thank you
Kate