Enter this formula in B1 as an array using the key combo of
CTRL,SHIFT,ENTER:
I'm not sure how to do that...
Also, when you say "Match(1," what are referring to with the "1"?
Thanks,
Leibtek
--
Leibtek
------------------------------------------------------------------------
Leibtek's Profile:
http://www.excelforum.com/member.php...o&userid=32287
View this thread:
http://www.excelforum.com/showthread...hreadid=520424