letter

current =COUNTIF(F:F,">1") need =COUNTIF(6,">1") thanks for looking Ross

Good day. I have columns of analytical data, some have a leading letter(s) as part of the lab result (i.e., U, UJ, E, B, R), some have no letter. There is a space between the letter and number: U 0.042 I need to reverse the string: 0.042 U If there is no letter (e.g., 0.042 or cell is...

Me.TextBox6.Value = .Sum(.Index(b, 3, 3)) Hello, I need a code which will show up in the textbox the total count values of letter "S" at column 3 How can I alter given above code? Thanks.

Hi, I have message box that I am trying to convert from a column number to column letter to make the code more user friendly as I was performing this on Column AC which is column 29 (much more confusing) How would I go about converting the column number to column letter for this code? c =...

Hi i am trying to setup a hyperlink formula for a file directory, normally as many people will be using this spreadsheet typically they will have saved the directory folder under different letter eg A:, C...

identify the 3 letter pattern in the draw line http://www.mediafire.com/file/27frtcym6d6ulxx/detectar_os_padroes_das_3_letras_no_sorteio.xlsx/file

Hello guys i have another question for you guys.... is there a VBA that can in active worksheet CLEAR the contest of a row in selected range...lets say i have text sorted in rows....and i want that i can with macro search for value or criteria text letter ž or in (english f for female) in range...

I have a sheet that when I enter the letter B in column A I need the top border for that row to be bold from column A to column AL. Thanks for your help as always.

Brand new to the forum and fairly new to Excel and my question is: Can I format a cell so when I place a letter it will represent a numerical value in a formula? Here's the scenario: I want to format a cell so when I type in the letter 'E' a multiplier of '1' is placed in a formula but the...

I will have an excel spreadsheet which will have a column for recipients, a column with their address, a column with their account number and a code for a specific text that I would want in the body of the letter. The end results that I'm going for is that based on the letter code that is...

Hi all, I am quite new to excel so pretty basic questions from me but I would appreciate your help. I am trying to work out how I would find the top 3 reasons for a particular month compared to another month with percentages. And if they have changed position. example. the data would be on a...

I currently have hyperlinks (within a large number of cells) that link to places within the same document, but the cell sizes are, by necessity, quite small, and the hyperlinked letter inside each of the cells is even smaller, therefore very hard to click on quickly ... usually I'll miss the...

I have a worksheet where I want a message box to appear when the letter "A" appears in the range I37:I69. I used to following code to accomplish this: Private Sub Worksheet_Change(ByVal Target As Range) If Not Range("I37:I69").Find(what:="AA", LookIn:=xlValues, lookat:=xlWhole...

Hi guys, I have a question regarding the best way to find the row number of a cell containing an exact string which in my example is a single letter. The problem I'm encountering is that this letter also happens to be within words of other cells. How would I go about returning only the row with...

Hi guys, I was wondering if you could help. I am try to create a formula which would pull the most common letter from a string. For example, cell A1 contains MMMWW, I would like the formula to return M Thanks!

Hello. This is my example data set. <tbody> A B C 1 1 A G 2 2 B 3 3 C 4 4 D 5 1 E 6 2 F 7 3 G 8 4 H 9 .... .... </tbody> With formula (in cell C1) =lookup(2,1/(A1:A10=3),B1:B10) I could find the last value in column B for a number 3 and result in cell C1 is...

I think what I'm trying to do is quite straight forward, but I just can't find the right functions or combination of functions to do - partly because some of the obvious functions don't allow wildcards. I have a column of cells which could contain one of five letters as the first character (P...

I need a macro to change the color of a cell based on the value in another cell. I have data in range C4:L4. The user will review the content of the cells in the range, and may enter the letter Y or the letter N in C5 or D5 or E5 and so on. If Y is entered in C5 I want the cell color for C4 to...

I am attempting to get a combined total for a range of cells that contain a number and letter. Example 8v+3v with it giving the answer of 8v. Any ideas?

Hello, I need to count the number of times the letter C appears in a range of cells but i need to excelude the duplicate values out of that count. Let me explain this better: <tbody> day1 day2 day3 day4 day5 day6 day7 day8 08:00 16:00 a a b 16:00 24:00 b </tbody> in this...