recode variable
 

Hello

I want to recode some survey results in Excel. Several questions need to be
"reverse coded". i.e. score of 6 really means 1, 5=2, 4=3 etc. I have found
a way to recode into a new column with the "choose" function. Can I recode
into the same column? I am using Excel 2007.

I am used to recoding in SPSS syntax.

Thank you

Robin

recode variable
 

Create a simple macro overwriting the original column with the recoded
column via Copy/PasteSpecial-Values!

Regards,
Stefi

€žRobinb€� ezt Ã*rta:

Hello

I want to recode some survey results in Excel. Several questions need to be
"reverse coded". i.e. score of 6 really means 1, 5=2, 4=3 etc. I have found
a way to recode into a new column with the "choose" function. Can I recode
into the same column? I am using Excel 2007.

I am used to recoding in SPSS syntax.

Thank you

Robin


.