Myriam,
For the life of me I can't think what could be causing it not to work
for you. Are A1, B1 and C1 all numbers or a mixture or numbers and
text? Because the formula would maybe need to be a hybrid of my
suggestion and Bob's if B1 or C1 contained text. I'm stumped
--
Casey
------------------------------------------------------------------------
Casey's Profile:
http://www.excelforum.com/member.php...fo&userid=4545
View this thread:
http://www.excelforum.com/showthread...hreadid=570872