numerical values

  1. A

    BEGINNER USER: Assigning Values to Letters in Multiple Columns

    Hi, please note that I am a novice excel user, so very explicit directions are appreciated. I am hoping to track students' reading level progression through the duration of the school year with an excel spreadsheet so it can be easily visually represented with a line plot. Fountas and Pinnell...
  2. B

    Turning non-numerical teams names into numerical values

    The school I work for is crafting a system where students have to do a sport, and depending on which sport they do they will earn a numerical value for that sport. Freshman would need 6pts, Sophomores ~4, Juniors and Seniors 3. I am looking at a way to input information into excel to keep...
  3. C

    Extracting numerical values from a sentence

    Hi, I'm currently working on a way to extract a value from a clinical report, example "The left ventricular ejection fraction is calculated as 61% ( normal value > 60%)". So far, I have been able to use a formula to extract the data (in this case 61%) by asking excel to find values after the...
  4. D

    formula for multiple texts to equal values

    I am hoping someone can help me. I have a spread sheet that has multiple columns with different texts, I would like to assign each text a value and calculate the total, for example: A1 has the word YES with a numeral value of 3 B1 Has the word Maybe with a value of 2 C1 has the word No with a...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top