View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
gimme_donuts gimme_donuts is offline
external usenet poster
 
Posts: 1
Default 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)