Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie
Help Keep Boards Alive. Support us by going ad free today. See here: https://subscriptions.boards.ie/.
If we do not hit our goal we will be forced to close the site.

Current status: https://keepboardsalive.com/

Annual subs are best for most impact. If you are still undecided on going Ad Free - you can also donate using the Paypal Donate option. All contribution helps. Thank you.

Excel - reverse coding

  • 18-11-2012 01:17AM
    #1
    lorr3
    Registered Users, Registered Users 2 Posts: 105 ✭✭


    Hi there! Just hoping someone can give me some advice on how to code and reverse code an excel file.

    Basically I will have a set of data in which each column represents a question.

    Column B -Question 1
    Column C - Question 2
    Column D - Question 3

    etc etc

    My problem is that while question 1 and 2 will be coded by;
    Agree = 1.....Disagree = 5

    Question 3 will be the opposite
    Agree = 5.....Disagree = 1

    If anyone can explain (as simply as possible, I am a total newbie :D) how I would code these, I would REALLY appreciate it?

    The questionnaire is likely to have 150+ questions and I dont think doing find and replace 5 times per column will work out too well!

    Thanks in advance! :)
    Tagged:


Advertisement