<< What happens if you have more than one D in the target range?
Unfortunately, the formula I suggested only works for unique entries in
a column. Thank you for pointing it out.
Regards.
--
BenjieLop
------------------------------------------------------------------------
BenjieLop's Profile:
http://www.excelforum.com/member.php...o&userid=11019
View this thread:
http://www.excelforum.com/showthread...hreadid=470999