recode variable

[Robinb]

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

 

[Stefi]

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

Regards,
Stefi

„Robinb†ezt írta: