jhk150 -

If you have one row for each respondent, then you can use Data | Sort with
the desired column as the sort key. Each row will remain intact. Make a
backup copy of the worksheet first.

- Mike Middleton
http://www.DecisionToolworks.com
Decision Analysis Add-ins for Excel



"jhk150" wrote in message
...
I am not able to sort the values because the data would not correspond with
the row with the respondent's ID number. Is there anything else I can do?

"BobT" wrote:

If the data is sorted (or can be) by the column with those numbers, then:

1. Sort the records by the column with numbers that need changing. This
will get all of the 1's together, and all the 2's together, etc.
2. Then highlight the 1's.
3. Press 5 then CTRL+ENTER. This places a 5 in all of the cells that
had a
1.
4. Repeat for the other numbers that need to be swapped.
5. Resort if needed after all the changes are made.

"jhk150" wrote:

I have data sets in only certain columns of my spread sheet that need
to be
reverse coded, i.e. 1=5, 2=4, 3=3, 4=2, 5=1 . How do I get these new
values
in Excel?