Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
asign a number to a text string
it has to be very easy but I have not found the way to do it.
What I'm tryig to do is some list of companies and for their services I want to use Yes for 1, No for 0, Sometimes for 0.5 and Maybe for 0.25. just asigning these numbers to the text is what I want, so that it is easely readable and editable for everyone and it still can make some addition of it in the end. Example: Kwik e-mart Fruits - Vegetables - Meat - Fish - Fresh Total score Yes Yes Sometimes No Maybe 2.75 To add this data, I used the validation function so that there is a dropdown menu for each criteria (Yes, No, Sometimes, Maybe) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Change 3 letter text string to a number string | Excel Discussion (Misc queries) | |||
Extract number from text/number string.. | Excel Discussion (Misc queries) | |||
Splitting a text string into string and number | Excel Discussion (Misc queries) | |||
How do I look up a number within a string of text | Excel Worksheet Functions | |||
How can I asign a number value to a text line in Excel? | Charts and Charting in Excel |