Re: How to "recode" data in Excel?

On 27 Mar, 01:24, "zencaroline" <zencarol...@xxxxxxxxx> wrote:
Hello,

I would like to recode 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?

Subtract the midpoint of the scale multiply by -1 and add the midpoint
again. For a five point scale the formula will be:

=((A1-3)*-1)+3

Where A1 is the original cell reference. (You don't need the outer
brackets but its usually easier to parse this way.)

Thom

.

Relevant Pages

  • Re: How to "recode" data in Excel?
    ... Might anyone know how to accomplish this task in Excel? ... Subtract the midpoint of the scale multiply by -1 and add the midpoint ...
    (sci.stat.consult)
  • How to "recode" data in Excel?
    ... I would like to recode data in Excel, i.e., making 5 become 1, ... Might anyone know how to accomplish this task in Excel? ... Please take care ...
    (sci.stat.consult)
  • How to "recode" data in Excel?
    ... I would like to recode data in Excel, i.e., making 5 become 1, ... Might anyone know how to accomplish this task in Excel? ... Please take care ...
    (microsoft.public.excel)
  • RE: Excel Challenge: Copy and pasting sheet1 to sheet2
    ... Only an Excel Enthusiast ... Since this is a long list and not all the cells in the qty column will be ... 2- Be able to email the summary sheet as an attachement ... Is there anyone that knows of a formula to use to accomplish this? ...
    (microsoft.public.excel.worksheet.functions)
  • Dynamically Create excel file
    ... I need to export data in a GridView to excel without having office installed ... I have tried to methods to accomplish this. ... In both methods I used the ASP.NET response property. ... installed on the server and without using third party controls. ...
    (microsoft.public.excel.programming)
Loading