Hi i tried that =ISNUMBER(AJ200) thing and it worked ok for the AJ
column, but when I did it for the Y column it returns false even though
i made sure the column was in Number format (no decimals) so i'm not
sure why its returnging false, thus im thinking this is why ur original
formula isnt working.
Thanks : )
--
vect98
------------------------------------------------------------------------
vect98's Profile:
http://www.excelforum.com/member.php...o&userid=26365
View this thread:
http://www.excelforum.com/showthread...hreadid=469366