I can do up to the point that you describe but then that still leaves me
with the values that don't have Y next to them.

I need both you see and don't really want to have to scan down the
entire list which is 3500.


--
mabbutt
------------------------------------------------------------------------
mabbutt's Profile: http://www.excelforum.com/member.php...o&userid=34294
View this thread: http://www.excelforum.com/showthread...hreadid=540598