Re: Converting Text To Numbers

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Gord Dibben (gorddibbATshawDOTca)
Date: 08/25/04 

Date: Wed, 25 Aug 2004 12:32:15 -0700

Justin

One more to consider.

=LOOKUP(A1,{"average";"excellent";"good";"N/A";"no";"poor";"yes"},{40;70;60;10;50;20;30})

NOTE: the values to lookup in the array must be in ascending order.

i.e. a-z in first half of array. Second half of array can be any order.

Gord Dibben Excel MVP

On Wed, 25 Aug 2004 08:49:05 -0700, "Justin"
<anonymous@discussions.microsoft.com> wrote:

>Thanks for all of your suggestions, you've made it sound
>too easy.
>
>I'll try each option and stick with the best.
>
>Thanks all!
>
>>-----Original Message-----
>>Hi
>>
>>One way:
>>Cell A1: Good
>>Cell A2: Bad
>>Cell A3: Ugly
>>
>>Cell C1: Bad
>>Cell D1: =MATCH(C1,$A$1:$A$3,0)
>>
>>HTH. Best wishes Harald
>>
>>"Justin" <anonymous@discussions.microsoft.com> skrev i
>melding
>>news:cdfe01c48ab4$f2bc7580$a501280a@phx.gbl...
>>> Hi
>>>
>>> I hope someone can help me with this one.
>>>
>>> I'm in the process of creating a spreadsheet which will
>be
>>> used to give pupils an overal score on specific
>projects.
>>>
>>> For example, the spreadsheet will have around 30
>questions
>>> to which I can select Yes - No - N/A, or Poor, Average,
>>> Good, Excellent. The problem I need assistance with, is
>>> how do I convert the selected answer (Poor, Average,
>Good
>>> etc) to a numerical score?
>>>
>>> Any help or advice will be greatly appreciated.
>>>
>>> Oh, and no, I'm not teaching IT!
>>
>>
>>.
>>

Relevant Pages

  • RE: Match function
    ... without one thousand formulae recalculating volatile). ... This is an array formula which must be entered by pressing CTRL+Shift+Enter ... Please tell me workaround given my numbers are in ascending order and a need ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Access a matrix row-wise without transpose?
    ... mean "I want to have vectors sorted by bb in ascending order"? ... random arrangement of 1's in the xx array. ... sort bb by using itself to sort in ascending order. ... to others, particularly those with the Crystal Ball Toolbox, it's ...
    (comp.soft-sys.matlab)
  • Re: qsort descending order
    ... in the detail of the qsort library function in 7.20.5.2, ... ascending order. ... You define what "ascending" means in your comparison function, ... we should be able to use the qsort to sort the array elements into ...
    (comp.lang.c)
  • Re: sorting int[] in descending order
    ... I know that one can sort in ascending order and reverse the array. ...
    (comp.lang.java.help)
  • Re: Reversible sort algorithm
    ... The job is to sort these numbers in ascending order ... The sorted array plus the sort-information will be ... of an available cell, ...
    (comp.programming)