letters to numbers

  1. W

    converting letters to numeric values

    I have a likert scale survey project in front of me. I need to take the survey answers and give them a numeric value. I then need the numberic value to populate on a calculation sheet. This survey will be used 100x over the next few months. Sheet one: 1. Question: Answer:_______ The...
  2. K

    Assign Numbers to Letters to get Max Letter

    Say you have a column A through F. With A being min, B greater than A, C greater than B, etc. So, then F would be the maximum. Now, what I want to do is return F (the maximum) in another cell. I know with numbers you just use =max(num1,num2…) but how do you do it with letters? I want to avoid...

Some videos you may like

This Week's Hot Topics