Alias
10-12-2012, 03:18 AM
Hello,
My VB knowledge is poor, but my program knowledge is okay.
I have rows in my excel sheet.
Each row contains one of two letters; S or F.
S = success
F = fail
I have been asked to find any row in the last month (dates are at the top of each column), where there has been 3 or more "F"s in a row. So basically on a run of 3 or more days where there is a fail.
If a row contains this, it keeps it, if there is no 3+ fails in a row, then remove it.
Can anyone advise how I would go about this? I'm assuming using a loop, and then maybe the COUNTIFS function, but I cant get anything to work...
My VB knowledge is poor, but my program knowledge is okay.
I have rows in my excel sheet.
Each row contains one of two letters; S or F.
S = success
F = fail
I have been asked to find any row in the last month (dates are at the top of each column), where there has been 3 or more "F"s in a row. So basically on a run of 3 or more days where there is a fail.
If a row contains this, it keeps it, if there is no 3+ fails in a row, then remove it.
Can anyone advise how I would go about this? I'm assuming using a loop, and then maybe the COUNTIFS function, but I cant get anything to work...