| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I make a letter represent a number?
Hi Ben, I suspect that the "countif" answers already given will have given you a way to solve your problem but... Another option (which will be helpful if you have more letters to match with a number than just x=1) involves the use of a lookup table eg, 1) Create a new worksheet & call it Lookup Table. 2) Put the alphabet in column A, one letter per cell ie cell A1=a, A2=b,...,A26=z. 3) Put the number you want to match with each letter in column B eg cell A24=x & B24 will =1. 4) Adapt this formula to be used on your working sheet: "=VLOOKUP(A1,'Lookup Table'!$A$1:$B$26,2,FALSE)" where the cell A1 contains the letter that you want to represent a number. hth Rob Brockett NZ Always learning & the best way to learn is to experience... -- broro183 ------------------------------------------------------------------------ broro183's Profile: http://www.excelforum.com/member.php...o&userid=30068 View this thread: http://www.excelforum.com/showthread...hreadid=531653 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Staff rota, how can I make a letter represent a shift? | Excel Discussion (Misc queries) | |||
| how can I make a form number change everytime the form is opened | Excel Worksheet Functions | |||
| Convert Text (letter) To Number Excel | Excel Worksheet Functions | |||
| how to add a letter in front of each number in a cell | Excel Discussion (Misc queries) | |||
| How do I get a letter to represent a number for scheduling? | Excel Worksheet Functions | |||
Threaded Mode
