letter

  1. R

    cells selection vba

    hi Guys Please find my drop box link https://www.dropbox.com/s/t87ax5n6l6exa8o/testing2018.xlsm?dl=0 When sanction letter is selected, sheet sanction letter is opened and cell A2 is activated.Same applies for other menus Today's date is inserted in A2,SL inserted in B2 ,002 is inserted...
  2. D

    Red text question

    ROUND(MOD((MOD(AVERAGE(U5/W5),365)),30),0)&"D" Is it possible to turn the letter "D" the color red Thank you for your help.
  3. F

    Which formula to use?

    <tbody> 1 2 3 4 5 6 7 8 9 10 a b c d e f day 1 1 2 2 2 3 4 4 5 6 6 6 a 12 a...
  4. T

    Need help with nested if statements using match

    Hi All, Struggling with an excel problem. I have one list (list 1) with IDs and a corresponding value (letter). Separately, i have a list of IDs (list 2) that I want to put the latest value for (see output columns for what i mean). I want to check first if a 2 -C exists, if not, check if a...
  5. Dazzawm

    Formula Please

    I have column C. I would like a formula please to give me a result of - if the last digit is a number then yes, if the last digit is a letter then no. Thanks.
  6. A

    Copying data based on a separate column

    Hi All, I am coming to you with a question regarding filling in large amounts of data. I have a script which generates a column of data based on a couple fields my end users fill in. The next step I would like to automate is filling in other fields of each row for each value generated by the...
  7. W

    Extract letter and numbers

    I need to extract the letter C followed by 3 numbers from cell A1 in this file. The code could be anywhere in the description. See example below <tbody> PIPING,6"F3-9906-C712-RXV </tbody>
  8. J

    Xcel VBA Finding Max Number in Column

    I have a column with the data formatted like this: <colgroup><col style="width:48pt" width="64"> </colgroup><tbody> L-15 S-6 L-7 L-8 R-9 D-10 S-11 D-15 R-13 L-6 </tbody> I am trying to find a...
  9. M

    SUMIFs - simple example

    Hi I've got a table where I want to add the sum of occurrences for two different letters (see below): A appears twice, B appears thrice and C appears 4 times. Assuming that this data covers two columns and 4 rows from cell A1, how would I write a SUMIFS formula that captures the number of...
  10. E

    How can I set the criterion 'if the cell is at the right of a specific cell' ?

    hello! How can I set the criterion 'if the cell is at the right of a specific cell' ? Or if the column of the cell is higher than a letter etc? Thanks!
  11. I

    Basic code required please

    Hi, I have a worksheet called Sheet1 On sheet1 is a Combobox1 which will have the names inside. These names are on a worksheet called TYPE and cells A1:A5 I would like the user to select a name then depending on the selection put a letter in cell P7 Here is the names & letter assigned to that...
  12. R

    Automatic ENTER.

    Howdy, Column A has name. In column B I have a formula that lists all the names that contain the letter / letters entered in cell D2. I need a VBA code to display my name in column B without having to press enter after each letter entered in D2. Eg. I write a letter - let's say - the letter a...
  13. K

    Rename_file names

    I have several hundred files in a folder which I need to rename in a specific order. I write the question as it was only 12 files in the folder. I need to add letter A_ to the first file name(0) in the folder, then letter B_ to the fourth file, letter C_ to the eighth. Then restart the loop on...
  14. D

    Extract a particular characters from a cell

    Hi Can some one please help me on the following. I have the following data , I only require the first letter after the 2nd dash if the letter is L or R or S and if the length of the characters after the second dash is 4 <colgroup><col><col></colgroup><tbody> Data Require BW1550T-NAV-L084 L...
  15. charlesstricklin

    Divide students by first letter of last name?

    The school where I teach has two Vice-Principals. All of our 7th grade students go to one or the other based on the first letter of the last name. Students with first letters of last names beginning with the range A-K go to one Vice-Principal, and the L-Z students goes to the other. How may I...
  16. F

    How to exclude all text up to and including a capital letter from the right

    Hi all, Could realy do with some help. The below formula extracts the text up until the 2nd capital letter, like ThompsonTaxi and it will return Thompson, great. But it is not picking up names with an apostrophe or double barrelled names. I need a formula that starts from the right and will...
  17. S

    Need combined average over multiple years using Vlookup or averageif?

    My Data basically looks like the table below... I'm trying to figure out a formula that will look up the letter in Sheet 2 find the corresponding letter in Sheet 1 and then determine the average of the 2017 and 2018 corresponding month. For example For the letter A the formula should return...
  18. A

    choose a name in list

    i have a question related to excel. plz help. i have created a list of different products by data validation. now in the new sheet i have applied it now i want to select a product in the list. now i want this: when i write a letter or 2 letter related to any specific product of the list, is it...
  19. L

    Dynamic Graph Help

    Hi, I have a table that isn't in the best format but this can't be changed. It looks something like the below.. <colgroup><col><col span="9"></colgroup><tbody> 201701 201702 201703 Department F L M F L M F L M Dept 1 61 71 63 53 87 50 63 74 19 Dept 2 87 46 75 21 70 50 26 37 41 Dept...
  20. T

    How to delete string from cells if it contains the letter x ?

    9X60X11 I have variations of dimensions such as the string above in my cells. Their position is not consistent. The only consistent rule is that the word I want to be rid off in all my cells contains the letter x, but how?

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