letter

Hi, I doing investment risk profiler in excel. Basically, what I want to achieve is that each letter on the questions corresponds to a number and based on the user's choice it will add up on the analysis box. The score then will be evaluated as aggressive, low risk, or mid risk. My question is...

Here is the formula i am using and it is working. =SUMPRODUCT(--(($A$56:$A$300>=3))*(EXACT(S$56:S$300;"AE")+(EXACT(S$56:S$300;"BE")+(EXACT(S$56:S$300;"RB"))))) I have a value that has to be >=3 in A56:A300. And i have two letter code in S56:S300 that might be AE, BE, qB, AB, BB, RB, PB ...

I have a font which has graphic symbols that I what to use in Excel. The font works perfectly in Word, but in Excel it displays the font letter instead of the symbol that is assigned to that letter in the font file. How can I get Excel to display the symbol that is assigned to that letter?

Hello, I would like to place a letter in all cells in column A when the cell next to it in column B has a number, and for it to stop running when the last cell in column B does not have a value. <colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody> P 1583194 P...

Hi, I have made a code where if I were to write out a name in a textbox the first letter will be capitalized. It also capitalizes the first letter whenever I add a space between names. So, I am having this problem where whenever I put a special character or a number (For ex...

Thanks in advance for any suggestions for which I will provide feedback. Why am I getting the error: "Run-time error '438': Object doesn't support this property or method" on the following line: Cells(4, i).Formula "= MATCH(TRUE,INDEX(E" & i & ":" & LastColumnLtr & i & "<>0,),0)" The...

Dear Excel Helpers, I need a help in excel macro. I have a word with draft of letter, and an excel sheet with list of recipients. I want to create a macro in which following actions happen 1. change the recipients name in the letter in MS Word from the list of names in excel 2. save the word...

A little while ago i was give this formula to help me re-order a list based on the fact that it is mixed letters & numbers. IE if a letter "R" is in the list then it becomes 1, if in the same list a 1 appears this becomes a 2 & so on =IF(A1="R",1,IF(A1=0,MAX(A$1:A$11)+COUNTIF(A$1:A1,0)+1,A1+1))...

I have scoured the internet and I cannot find anyone trying to do specifically what I am doing in Excel, so hopefully you can help. Consider the following table (Range"A1:D16"): <tbody> <tbody> College </tbody> <tbody> Score Range Min </tbody> <tbody> Score Range Max </tbody>...

Hello, Is there anything add to below formula that will avoid the error? If there are letter at on the target cells(column B) it shows #VALUE! =SUMPRODUCT((E5:E84="L")*B5:B84) Thank you.

I am sorry if this has been asked before. I tried to search but did not have any luck. I am looking to have placeholders in an excel spreadsheet for multiple cells and on multiple sheets. I would like to see the very simple thing to help accomplish this. What I am needing is for any cell I...

Is there a way to use the COUNTIF function to count cells if they contain a single letter - for example below, when a cell has the letter A, the count would be 3 in the top row <tbody> 3 12345 A4567 3546 23A78 765 2A6A8 </tbody> I thought it would be easy using...

A very helpful board memeber gave em this code to open an input box as a search for data in the column Range("c2").AutoFilter 3, InputBox("Please enter the search letter") & "*". I am trying to get it to un in column a instead so I entered Range("a2").AutoFilter 1, InputBox("Please enter the...

I have a string of numbers and letters and need to extract everything after the first letter. Example 456trust 4file 5867hampton 24grate

Hi, I work for a charity near Liverpool (UK) and need some help please. When we send our template introduction letter to our beneficiaries we have to include a selection of 5-10 (out of around 50) standard paragraphs of text to insert into a letter. Currently we use Word 2016, and set up a...

I am looking for a formula that will allow me to count text less than 2 and exclude blank spacing. So if it is one letter it would be wrong and if its one letter with a space it will still be counted as wrong. 2 Characters is the min. Please help

Hi Everyone, I need a macro that runs macro "Do the Ds" if someone clicks in the the range "D12:AXY1500" and the cell contains text starting with the letter "D". keep getting errors please help if you can Thanks Tony

Is there a Macro To Delete All Rows When The Last Letter In Column A is An N please. What would be beneficial is a code with an input box so I can put the letter as I will use it on all different occasions. Thank.

Hi, I have a hyperlink I use and there is a cell I manually enter to put a client's names. As a result the hyperlink concatenates this to form the hyperlink. However, the directory is going to be split from A-L and M - Z. Is there a formula that can pick up the first letter of the client...

Hello to all, Would like to seek help in relation to cell conditional formatting with different conditions. What I would like to happen is at cell B2 I can input 1 letter (x, m,a, or n) which has a corresponding cell color at cell B4. If i input letter "X" on cell B2, Cell B4 will change to...