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)
  • Re: Repetitive Task
    ... though I am new to Microsoft Project. ... In excel, I accomplished this by one cell with the current totals ... there is an easy way to accomplish this, though I must not have gotten ... If you are good in VBA, you can also edit the Macro script to repeat ...
    (microsoft.public.project)