In Column B I have "Job No" and in Column C I have "Open/Closed".

Col B Col C
1001 Y
1001 Y
1003 N
1003 Y
1005 N
1005 N


In Col A I need to create a function which goes through job nos and i

at least one has a "Y" then a Y is given, so the result of the abov
would be:

Col A Col B Col C
Y 1001 Y
1001 Y
1003 N
Y 1003 Y
1005 N
1005

--
T De Villier
-----------------------------------------------------------------------
T De Villiers's Profile: http://www.excelforum.com/member.php...fo&userid=2647
View this thread: http://www.excelforum.com/showthread.php?threadid=39761