Re: How to "recode" data in Excel?
Tech-Archive recommends: Fix windows errors by optimizing your registry
If your number is in A1, then this formula will transform it as you
require:
=6-A1
Copy it down for as many items as you have.
Hope this helps.
Pete
On Mar 27, 1:23 am, "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?
I know SPSS can do this. But I need to recode 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
.
Relevant Pages
- 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: 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? ... Subtract the midpoint of the scale multiply by -1 and add the midpoint ...
(sci.stat.consult) - RE: SSIS string to int when a preceeding letter
... A four letter word for dba's and database developers! ... Use an OLE DB connector for the Excel file instead of the stock Excel ... Rows" to a Derived Column Transform. ... there is no CASE construct in SSIS. ...
(microsoft.public.sqlserver.dts) - Re: DTS Transform Loop
... controls and SQL Task), but now I need to add a data transform in there. ... Execute the transform after each loop step? ... You should loop with one transform task from Excel to SQL Server and import each file one after the other. ...
(microsoft.public.sqlserver.dts) |
|
