recode variable

R

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
 
S

Stefi

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

Regards,
Stefi

„Robinb†ezt írta:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to "recode" data in Excel? 1
Range headings 0
Automatically sending multiple parts of text from one word doc to another - is possible. 0
Embed the same Excel multiple times 0
Input pages 0
Solution to tricky problem of showing exactly Top N rows in Pivottable 0
Look Up Formula With Veried Search Range 2
3 LookUp Variables One Result 2

Top