Forum Discussion
Reverse scoring
Hi, Is there an automatic way to reverse score? I know the equation but it is slow and clumsy when you have multiple columns to reverse score. Thanks.
Hi Jayqwellen ,
Sorry I'm a little late to the party but thought I'd chime in since others may encounter a similar problem.
I managed a quick-fix reverse score on a four-point Likert scale over 10 columns of 5000+ rows by:
- Highlighting all columns containing the data to be reversed
- Hitting CTRL+H to bring up the REPLACE function
- Replacing 1 with 10, 2 with 20, 3 with 30, 4 with 40
- Replacing 40 with 1, 30 with 2, 20 with 3, 10 with 4
Note I didn't just replace 1 with 4 off the bat since this would have conflated my newly-reversed 4s with my existing 4s, and the same for my newly-reversed 3s. Using 10s, 20s etc provided a quick code to sidestep this problem.
Best,
DC