You can't get a formula to "push" a value to another cell, so you could
not automatically add a missing item to the list - you will need VBA
for that.

Hope this helps.

Pete

financier wrote:
Thanks, I'll look into that. Any other ideas folks? I got the first half
down using a formula, to find that a symbol is there using MATCH, but
the rest I"m clueless on...


--
financier
------------------------------------------------------------------------
financier's Profile: http://www.excelforum.com/member.php...o&userid=36260
View this thread: http://www.excelforum.com/showthread...hreadid=560523