Hi kiran

In B1 use this formula and copy down
=IF(A1="yes",1,0)

--
Regards Ron de Bruin
http://www.rondebruin.nl



"kiran" wrote in message ...
I have a column with values yes no as mentioned below i want 1 if value is
yes 0 if value is no in next column
yes
no
yes
yes
no
no
yes
yes