Hi guys, I'm trying to insert a formula in my code which works in the sheet but not in vba. Running the code below returns a syntax error. I noticed that the errors are due to SEARCH strings containing paratheses for "ENO=" and ",SUB". I've tried changing the paratheses to CHR(34) as well but...
I'm looking for a formula that would cause a number value to either increase or decrease by one. Examples of text include: Apr Y0, May Y0, Jun Y1, Jul Y4. The common denominator is that the number is always preceded by " Y".
Thanks in advance for all your expertise! Please let...
First post, hopefully I've followed the rules. I've had a good search but can't find anything specific to the issue I am having. It's very basic so I'm surprised it isn't working.
I've attached an image that hopefully clearly explains the issue I am having. Basically I'd like to...
I know this has been asked a thousand times and I'm trying to implement some of the solutions I've found but I just can't seem to get this to work. I have values in column I that four decimal places deep and I simply want to remove the last two characters. The problem I'm noticing...
I am using a formula which uses LEN and SUBSTITUTE. The formula works (I didn't learn it by building up, I got it from a tutorial), and I understand what LEN and SUBSTITUTE do separately, however, I don't understand what they are doing in this formula.
I was hoping anyone would explain...
Can someone assist me in writing a formula for counting how many "I" are in a range of cells. For example I have a range of cells B11:AF12 that have different letters in it to identify the kind of Lead Source we receive. "I" represents Internet. I need to find out how many I's are in...
Hi, Hope that someone can help me if this is possible to do in a formula.
Sorry that I can't post screenshot of table because I couldn't get the add-in to work. :sad:
Name Run Out
Tim 6 1
John 5 3
Len 6 3
John 3 4
Len 4 2
Tim 2 3
How i would like to...
This on has me baffled and I tried everything I could think of. Longstory short, I'm working with an old windows program that extracts data into anexcel worksheet. There are a ton of rows,but many are useless (like headers, totals, other stuff) Anyway, I did discover that the data I...
I need help with the funtion I am able to do len first and then if function but i cannot get them to work together.
I need a function that can take the Length of the numbers in cell B17 and if greater than or equal to 8, display a value of "Cusip" If the length is less than or...
My Task is to Summarize the Ingredients By Categories. I have two Worksheets/Tables. The First lists the Categories and their respective Recipes
Next is the...
I have a value in a5 (82700000) Needing it to display in a6 as text 82.7 Million. Could also be 827000000, needs to be displayed as text 8.27 Billion
I know it has to do with Len
Just cant get there,
Any tips or solutions are greatly appreciated.
I am trying to make a formula which basically says "find the first word that starts with G then choose the word AFTER it" but i cant configure the formula correctly, i am a bit of a novice!
i can do it by combining IF statementslike this:
Hi I am trying to pull from the sheet below into my cell the first and last name from Job Costing. In the sheet below first name is in C2 and last name is in B2. Then eventually I would scroll down. I looked up =Right Len, but confused its saying maybe I need to do =Left len any help thanks...
Hello wise people of the internet.
I'm tinkering with a code in VBA. It's purpose is to look at each cell in a given range.
Part 1: Looking at the LEFT side of a string, it searches for "/56-Test1/" And it MUST be the first part of a string.
Example: "A/56-Test1/AAA" should be ignored while...
I have the following example URLs:
The length is...
Below is my code:
Dim xArr() As String
Dim xAddress As String
Dim Rg As Range
Dim Rg1 As Range
On Error Resume Next
xAddress = Application.ActiveWindow.RangeSelection.Address
Set Rg = Application.InputBox("please select...
My current formula is =SUMPRODUCT(--(A11>='Front End'!B$25:B$72),--('Front End'!C$25:C$72>=A11+"00:15"))+SUMPRODUCT(--(A11>='Combo EE'!B$36:B$69),--('Combo EE'!C$36:C$69>=A11+"00:15"))
I'm having an issue because when I copy data in the range C25:C72 and B25:B72 the time now has a date in...
I am using Len Function to count number of characters:
Now, I have instances that I would like to count as one character and not 2. For example, instances like "DZ" or "LJ", if they exist anywhere in the word it should be counted as -1 to the total of characters. I can solve this...