If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Alpha and numeric
Is there a way to recognise an alpha entry in a range of cells and give them a corresponding numeric value in order to total them?
eg The letters C or G in a cell has a value of .20 and the letter R is zero? Thanks in advance for any assistance |
#2
|
|||
|
|||
Alpha and numeric
If you are talking about a single character in each cell...........this
could easily be done with a straight VLOOKUP.............if you are talking about multiple characters in each cell, then they must first be seggregated out individually before using VLOOKUP, unless you are talking about only a very few combinations, which might be handled with an IF formula. hth Vaya con Dios, Chuck, CABGx3 "Hammy" wrote in message ... Is there a way to recognise an alpha entry in a range of cells and give them a corresponding numeric value in order to total them? eg The letters C or G in a cell has a value of .20 and the letter R is zero? Thanks in advance for any assistance |
#3
|
|||
|
|||
Alpha and numeric
Dear CLR,
I thank you very much for your assistance which was of great help. I have only one character in each cell and only a few that need to be counted so your suggested IF formula worked a treat. However I have a further complication in that some characters have a numeric value which is less than 1 eg D=1, BUT C=.20 AND G=.25 Can I still still use IF formula, and if so can you tell me the formula. My D formula is =COUNTIF(F9:AI9,"D") Again I thank you for your time and expertise. Regards Hammy |
#4
|
|||
|
|||
Alpha and numeric
Please ignore my previous request for help. I decided to try the same formula with *.20 or *.25 at the end, and as you know it works a treat.
Sorry to be so dim but I really am a novice when it comes to anything computerised. Thank you for your original help which got me to this level of understanding simple Excel. Regards Hammy |
#5
|
|||
|
|||
Alpha and numeric
You're more than welcome Hammy, glad you got it figured out and all is
working well for you now, and thanks for the feedback. These groups are wonderful places to come to learn, and occasionally to help others.........just read other peoples posts and the solutions, and you will quickly see that there is usually more than one way to "skin an Excel cat".........then you can just use the one that you're more comfortable with.......keep coming back......... Vaya con Dios, Chuck, CABGx3 "Hammy" wrote in message ... Please ignore my previous request for help. I decided to try the same formula with *.20 or *.25 at the end, and as you know it works a treat. Sorry to be so dim but I really am a novice when it comes to anything computerised. Thank you for your original help which got me to this level of understanding simple Excel. Regards Hammy |
Thread Tools | |
Display Modes | |
|
|