How to record data in Excel?

  • Thread starter Thread starter zencaroline
  • Start date Start date
Z

zencaroline

Hello,

I would like to record data in Excel, i.e., making 5 become 1,
making 4 become 2, making 2 become 4, making 1 become 5, to change the
direction of negative-worded item questions.

Might anyone know how to accomplish this task in Excel?

I know SPSS can do this. But I need to record the data in Excel
in order to do other tasks.

Thank you very much and look forward to your kind reply.

Please take care

Caroline
 
See your other post - try this formula:

=6-A1

if your number is in A1. Copy down as necessary.

Pete
 

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
How to randomly split a whole dataset into two sub-dataset? 4
How to RANDOMLY split a whole dataset into two sub-dataset? 3
How to do listwise deletion in SPSS or Excel? 2
how to select out the valid cases without missing data, using listwise deletion 1
Looping through a table's records and changing, then resorting 0
How to extract duplicate records from 4 spreadsheets into a separate spreedsheet? 2
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0

Back
Top