letter

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

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.

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

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

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.

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

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>

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

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

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!

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

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

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

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

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

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

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

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

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

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?