ifelse

Hi, I need to perform binning on a time range using if else statement. Can anyone help me with the formula? I can't seem to get it to work... Attached is the excel screenshot to help show what I am trying to accomplish. Thanks.

Hello, Please help me. When I have to work on Date, I often spend a lot of time working. How to use vlookup when we have Date to consider.

Lets see if I can even describe this correctly... I have a userform that uses option buttons to help place certain shapes and then assign text to/around those shapes. Part of the userform is in the image below and an example of what I'm trying to do in the other image. My question is around...

Hi, can someone have a look at the code below. It's long, but repetitive. Each IF statement works but only for the first IF comparable, and the ELSE. All of the ElseIF's don't seem to be working and I can't figure out why. Trying to spruce up the holiday tracker for my workforce. Column "AS"...

I have a piece of code that I need to exit sub if criteria is not met. Not sure how to solve this with exit or end sub...Tried with else function but cannot get it to work. Sub COPY_PARCEL_HEADER_2() LR = Sheets("SAP MMT").Cells(Rows.Count, "C").End(xlUp).Row myCopyRow = LR + 1...

Hi, good evening everyone. I would like to ask question that I've been stuck for a very long time, so I made a decision to ask in this forum. Roughly, I have TWO(2) worksheets. One sheet is Onhand, another sheet is input. This is table for sheet Onhand, <tbody> Column A Column B Loc...

I have some basic knowledge and came up with a if else statement for 1 condition.. but unsure of what to do with 2 conditions. so, If Column A says Employee, then do below. Sub Employee() Dim Days As Integer Dim result As String Days = Range("B2:B11").Value If Days >= 41 Then result =...

If IsNumeric(ThisWorkbook.Sheets("sheet1").Cells(RowCounter, "A")) = True Then Call Method End If InitialRow = InitialRow + 1 Next MsgBox ("The End") End Sub Hi All, Above is the Code if the Column A has a Character go to Next line Works Perfect. BUT it Exits...

Hi All, I have a very strange condition where I have to get my answer in a single cell. Note: I do not want to populate any randome cell and refer that in my cell function. See the below table: COLA COLB COLC COLD 123 123 Y 223...

If ((char = ",") And (cou >= 10)) Then add = add + char + vbNewLine c = 1 cou = 0 Else add = add + char c = 0...

What is the difference between if else and case statement.

Hi all, I'm having trouble with the argument below.... <tbody> 2005 2005 2005 2006 2006 2007 2008 2008 2008 2009 Jan Feb Mar Jan Jun Jan Jan Feb Mar Feb 1 2 0 0 0 3 1 4 4 2 2 3 5 5 0 9 9 0 0 0 1 2 3 0 0 3 1 4 4 2 2 3 0 0 0 4 0 0 0 1 </tbody> I want to find out how may years hold...

I have several Sheets involved but I'll have Sheet 2 Active. When I'm on "Sheet 2" I need to know when cell ("C14") becomes active with an IF statement I'm guessing. Once it becomes active, I then need to know if the string in cell ("B2") on Sheet 1 = "Fighter" then I want to insert "some...

Hi There, It seem easy at first but I can't think of another way and needa bit of direction. I have series of UK registered vehicle, I need to identify the new and old i.e. Any vehicle registered before 2000 is old everything else is New, Since the format changed at 2000, I can get unique...

Hiiii, I have the following code below and what it does it create another excel document from the information gathered from the initial document (source). So what i want to do now is create a statement that will do some checking for me: If column E and F has values, then i want to take F...

Hi all, Hope you all are fin and doing well I don't know if any such post is already there as I searched and couldn't find the desired match. The first column is "CE" , second "CG" third "CH" Firstly I want the date and time in both "CE & CG" get seprated in any other column. I want to...

I have this code (see below) that goes thru column L to see if the something is true or not and if it is true it sends an email to the email address in column 15. I am using my email address as a test to make sure it works and it is sending me 100's of emails. Is there anyway to have all the...

I have dates in column L that have the conditional formatting of: Cell Value <= Today()-365*(3*$N7:$N$368)-182 I need to loop thru every row in column L and see if the conditional formatting is true or not. I know C pretty well but am still farely new to VBA and arent quite sure how to do...

Here's fun! :) I'm helping a friend who is trying to work out how much to charge for house calls. He has lots of data. The average house call lasts about 15 minutes, but some as low a 5 mins, some as high as two hours. We're trying to work out if he should have a minimum billiing period, and...