Data Coding

W

Whois Clinton

Hi,

I would like to set up codes for faster data entry, similar to SPSS options.
For instance:
Entering 1 would display Minimal
Entering 2 would display Moderate
Entering 3 would display Severe
Entering 4 would display Maximum

There would be several variations on the above idea such as department names
etc. Is there any help or existing references for such topics?

Thanks in advance
Clint
 
T

Tim879

You can use Microsoft's autocorrect feature so everytime you type
"min" it would replace it with minimal.

Another option would be to use lookup tables so the user would enter
in 1 then the lookup table would return "Minimal" in another cell.
 
W

Whois Clinton

Thanks, the look up table was closest to what I was hoping for. Thanks for
your time!
Clint
 
Top