Hello everyone,
I have a problem that I couldnt figure out.
For example, the values (5- Likert scale) I have in the first column:
strongly agree
agree
undecided
disagree
strongly disagree
disagree
disagree
agree
undecided
agree
.
.
.
.
.
etc.
And each value has a rep. number.
strongly agree=1
agree=2
undecided=3
disagree=4
strongly disagree=5
What I want to do is, for example
if the first cell is "agree", in the next colum it should be seen as "2";
in the second cell, if the value is "strongly disagree", it should be "5".
Is there a formula to do this? I really appreciate any help.
Molly.
Bookmarks