Sheet_1 has the following in columns A & B:
001 Y
003 N
002 Y
002 N
001 Y
Column A of Sheet_2 has sorted, unique values from col A of Sheet_1:
001
002
003
I'd like a formula for Column B of Sheet_2, that finds every instance of the
value in column A and compares its Column B values in Sheet_1, such that if
all are Y it returns Y, if all are N it returns N, but if some are Y and some
are N it returns Y.

The expected results would be:
001 Y
002 Y
003 N
Any help is greatly appreciated!
--
Thanks