How to allocate a value to a data(alphabet)

I would like to create an excel formula that could help me “allocate” a value to an alphabet.

 

Say for an example,

I create a table 

|A|4| which means (A=4)

|B|3| which means (B=3)

|C|2| which means (C=2)

|D|1| which means (D=1)

and I have a whole lot of data entered into (say for example) column A, with alphabets of random (A,B,C and D).

I would then like to use the cells in column B to translate these alphabets to an allocated numerical value (as shown above). 

What would be the solution?

I hope to hear from you soon! Thanks!

P.S You can use any form of formula(not limitting to creating a table specifically to allocate the numerical value. (i.e. create a formula that may or may not refer/look-up to the table above)

By: Marcus Benedict

349 thoughts on “How to allocate a value to a data(alphabet)

  1. house cleaner las vegas

    Good day! I know this is kind of off topic but I was wondering which blog platform are you using for this site? I’m getting fed up of WordPress because I’ve had problems with hackers and I’m looking at options for another platform. I would be fantastic if you could point me in the direction of a good platform.

  2. John Deere Repair Manuals

    My spouse and i ended up being absolutely peaceful when Jordan managed to complete his studies from the ideas he made when using the blog. It’s not at all simplistic just to always be handing out procedures which often the rest might have been trying to sell. So we see we’ve got the writer to appreciate because of that. All of the explanations you’ve made, the easy site navigation, the friendships your site help foster – it’s all incredible, and it is leading our son in addition to the family feel that the situation is fun, and that is exceptionally indispensable. Thank you for the whole lot!

  3. travel blogs 2019

    With havin so much written content do you ever run into any problems of plagorism or copyright infringement? My website has a lot of exclusive content I’ve either created myself or outsourced but it appears a lot of it is popping it up all over the internet without my permission. Do you know any methods to help protect against content from being stolen? I’d definitely appreciate it.

  4. klook blog

    Incredible! This blog looks just like my old one! It’s on a entirely different topic but it has pretty much the same layout and design. Outstanding choice of colors!

  5. cheap family holidays

    Do you have a spam problem on this site; I also am a blogger, and I was wanting to know your situation; many of us have created some nice procedures and we are looking to swap strategies with others, please shoot me an e-mail if interested.

  6. travel insurance cruise cover

    Hey just wanted to give you a quick heads up. The words in your article seem to be running off the screen in Internet explorer. I’m not sure if this is a formatting issue or something to do with internet browser compatibility but I thought I’d post to let you know. The layout look great though! Hope you get the issue resolved soon. Many thanks

  7. ig

    Howdy! This is my 1st comment here so I just wanted to give a quick shout out and say I
    genuinely enjoy reading through your articles.
    Can you recommend any other blogs/websites/forums that
    go over the same topics? Appreciate it!

  8. superb maids

    I’m curious to find out what blog system you happen to be working with? I’m experiencing some minor security issues with my latest blog and I would like to find something more safeguarded. Do you have any recommendations?

  9. Swing set assembly

    In these days of austerity as well as relative anxiety about running into debt, many people balk against the idea of making use of a credit card in order to make acquisition of merchandise or pay for any occasion, preferring, instead just to rely on this tried and also trusted technique of making transaction – raw cash. However, if you have the cash available to make the purchase entirely, then, paradoxically, that’s the best time to use the card for several motives.

  10. เช่าเก้าอี้

    naturally like your website but you need to check the spelling on quite a few of your posts. Several of them are rife with spelling issues and I find it very troublesome to tell the reality on the other hand I will surely come back again.

  11. DC day party

    Hello I am so delighted I found your website, I really found you by accident, while I was searching on Google for something else, Nonetheless I am here now and would just like to say thanks a lot for a tremendous post and a all round thrilling blog (I also love the theme/design), I don’t have time to read through it all at the minute but I have saved it and also added your RSS feeds, so when I have time I will be back to read more, Please do keep up the fantastic work.

  12. muaban-vietnam.com

    Hello would you mind stating which blog platform you’re working with? I’m planning to start my own blog soon but I’m having a tough time deciding between BlogEngine/Wordpress/B2evolution and Drupal. The reason I ask is because your design seems different then most blogs and I’m looking for something unique. P.S Sorry for being off-topic but I had to ask!

  13. DC movers

    Wonderful website. A lot of helpful information here. I’m sending it to several friends ans additionally sharing in delicious. And of course, thank you on your sweat!

  14. you can look here

    You could certainly see your expertise in the work you write. The arena hopes for even more passionate writers like you who are not afraid to mention how they believe. At all times follow your heart.

  15. Pool table assembly

    I’ve been exploring for a little for any high quality articles or weblog posts on this sort of space . Exploring in Yahoo I eventually stumbled upon this website. Reading this info So i am glad to exhibit that I’ve an incredibly just right uncanny feeling I found out exactly what I needed. I most indisputably will make sure to do not fail to remember this website and provides it a glance regularly.

  16. Silver spring Movers

    I do believe all of the ideas you’ve offered to your post. They are really convincing and will definitely work. Still, the posts are too brief for beginners. May just you please extend them a bit from subsequent time? Thank you for the post.

  17. Swing set assembly service

    Great – I should certainly pronounce, impressed with your website. I had no trouble navigating through all the tabs and related info ended up being truly easy to do to access. I recently found what I hoped for before you know it in the least. Quite unusual. Is likely to appreciate it for those who add forums or something, website theme . a tones way for your client to communicate. Nice task.

  18. Cameroun

    You actually make it seem so easy with your presentation but I find this topic to be actually something that I think I would never understand. It seems too complicated and extremely broad for me. I am looking forward for your next post, I will try to get the hang of it!

  19. DC apartment movers

    We’re a group of volunteers and opening a new scheme in our community. Your web site offered us with valuable information to work on. You’ve done an impressive job and our entire community will be grateful to you.

  20. Konsultasi emiten

    Generally I do not read article on blogs, but I wish to say that this write-up very forced me to try and do so! Your writing style has been surprised me. Thanks, very nice article.

  21. Need Help Writing an Essay?

    I simply had to say thanks all over again. I’m not certain the things I could possibly have accomplished in the absence of the type of creative ideas discussed by you over this concern. Entirely was the depressing circumstance in my circumstances, however , finding out your skilled form you managed it forced me to cry with gladness. I’m grateful for your guidance and as well , believe you recognize what a powerful job you happen to be carrying out educating many others using your webpage. Probably you’ve never got to know all of us.

  22. how to get a job in dubai on visit visa

    Can I simply say what a reduction to find someone who truly knows what theyre speaking about on the internet. You positively know how to bring a problem to gentle and make it important. More folks must read this and understand this aspect of the story. I cant believe youre not more well-liked since you undoubtedly have the gift.

  23. DC Moving help

    What i do not realize is actually how you’re now not actually a lot more smartly-preferred than you may be now. You are very intelligent. You know therefore significantly on the subject of this topic, made me in my opinion believe it from a lot of various angles. Its like women and men don’t seem to be fascinated except it¡¦s one thing to do with Girl gaga! Your individual stuffs great. At all times take care of it up!

  24. Office movers

    Nice weblog here! Also your site rather a lot up fast! What host are you using? Can I am getting your affiliate hyperlink on your host? I want my web site loaded up as fast as yours lol

  25. เช่าเก้าอี้

    Thanks for sharing your ideas. I would also like to express that video games have been at any time evolving. Modern technology and inventions have made it simpler to create realistic and enjoyable games. Most of these entertainment games were not actually sensible when the concept was first of all being experimented with. Just like other kinds of know-how, video games way too have had to evolve via many decades. This is testimony to the fast continuing development of video games.

  26. โต๊ะ รู เล็ ต

    Attractive section of content. I just stumbled upon your web site and in accession capital to assert that I get in fact enjoyed account your blog posts. Anyway I’ll be subscribing to your augment and even I achievement you access consistently quickly.

Comments are closed.