how do I re-code nominal data into numeric values
 

Hi, I have a lot of data from an electronic survey that needs coding into
numeric values and was wondering if there are any EXCEL formulas or macros or
something that are able to do this? The closest thing I've found is a Logic
function but i need more than the option of providing "true or false". For
example, one of my scales had five points ranging from never - always. I need
to be able to change never = 0, rarely = 1, sometimes = 2, mostly = 3, and
always = 4. It will take me days to re-code it all manually I need - HELP!

how do I re-code nominal data into numeric values
 

Source data assumed in A1 down, eg: sometimes
In B1:
=VLOOKUP(A1,{"never",0;"rarely",1;"sometimes",2;"m ostly",3;"always",4},2,0)
Copy down as far as required
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:18,100 Files:360 Subscribers:56
xdemechanik
---
"No time to waste, please help!" wrote:
Hi, I have a lot of data from an electronic survey that needs coding into
numeric values and was wondering if there are any EXCEL formulas or macros or
something that are able to do this? The closest thing I've found is a Logic
function but i need more than the option of providing "true or false". For
example, one of my scales had five points ranging from never - always. I need
to be able to change never = 0, rarely = 1, sometimes = 2, mostly = 3, and
always = 4. It will take me days to re-code it all manually I need - HELP!

how do I re-code nominal data into numeric values
 

Thanks Max sooo much, very very much appreciated! The thought of having to do
all of it manually was too distressing! My hero! xx

"Max" wrote:

Source data assumed in A1 down, eg: sometimes
In B1:
=VLOOKUP(A1,{"never",0;"rarely",1;"sometimes",2;"m ostly",3;"always",4},2,0)
Copy down as far as required
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:18,100 Files:360 Subscribers:56
xdemechanik
---
"No time to waste, please help!" wrote:
Hi, I have a lot of data from an electronic survey that needs coding into
numeric values and was wondering if there are any EXCEL formulas or macros or
something that are able to do this? The closest thing I've found is a Logic
function but i need more than the option of providing "true or false". For
example, one of my scales had five points ranging from never - always. I need
to be able to change never = 0, rarely = 1, sometimes = 2, mostly = 3, and
always = 4. It will take me days to re-code it all manually I need - HELP!

how do I re-code nominal data into numeric values
 

Welcome, glad it helped.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:18,100 Files:360 Subscribers:56
xdemechanik
---
"No time to waste, please help!"
wrote in message
...
Thanks Max sooo much, very very much appreciated!
The thought of having to do all of it manually was too distressing!
My hero! xx