if the cell containing the X is A1 and the cell in which you want the
value is B1 then the formula in B1 is =if(a1="X", 1,"")

hope this helps


--
tony h
------------------------------------------------------------------------
tony h's Profile: http://www.excelforum.com/member.php...o&userid=21074
View this thread: http://www.excelforum.com/showthread...hreadid=561997