letter

  1. R

    Risk Profiler

    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...
  2. D

    SUMPRODUCT and EXACT problem

    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 ...
  3. R

    How to use a graphic font

    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?
  4. D

    VBA to assign letter in cell next to a cell with a number

    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...
  5. J

    Capitilization After Special Character

    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...
  6. O

    VBA Code to Get the Column Letter for the First non-Zero

    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...
  7. P

    Changing recipient name in a letter draft in MS word from a list in MS Excel

    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...
  8. P

    re-order a list based on different citeria

    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))...
  9. B

    Return a Value Based on a Range Criteria AND a String Match Criteria

    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>...
  10. A

    Suproduct formula calculation error

    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.
  11. Q

    Placeholder

    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...
  12. A

    COUNTIF question - counting cells which contain a specific letter...

    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...
  13. W

    Index box with autofilter

    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...
  14. S

    Extract until first letter

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

    VBA copy excel into template Word document

    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...
  16. N

    Counting Text String Less Than

    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
  17. T

    On click macro if cell starts with "D"

    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
  18. Dazzawm

    Macro To Delete All Rows When The Last Letter In Column A is An N

    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.
  19. S

    Automatically change hyperlink

    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...
  20. I

    Conditional formatting: Cell color based on text input

    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...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top