Loop to Check Results

OldFella · Jun 17th 2017

I have a worksheet with test results in Col F and Col K. Col F will show either >10 or a value between 0 and 10; Col K will show either >5 or a value between 0 and 5. In Col D I want to test if Col F shows >10 and if Col K shows >5. If both these conditions are true then P is to be entered in in Col D; if either condition is false then F is to be entered in Col D. Hopefully that's clear but in case not, here's a sample of how my worksheet would look:
[ATTACH=CONFIG]72759[/ATTACH]
Can somebody please help me with a loop that will achieve this as I'm unable to figure out how to test two simultaneous conditions. My data starts in row 5. Thanks in advance.

**KjBox** · Jun 17th 2017

Re: Loop to Check Results

Try this in cell D5 and copy down

=IF(AND(F5=">10",K5=">5"),"P","F")

**KjBox** · Jun 17th 2017

Re: Loop to Check Results

If you really need a macro loop then try this

Code

Sub PorF()
    Dim i As Long
    
    With ActiveSheet
        For i = 5 To .Cells(.Rows.Count, 6).End(xlUp).Row
            If .Cells(i, 6) = ">10" And .Cells(i, 11) = ">5" Then
                .Cells(i, 4) = "P"
            Else
                .Cells(i, 4) = "F"
            End If
        Next
    End With
    
End Sub

Display More

OldFella · Jun 17th 2017

Re: Loop to Check Results

Wonderful! That's the second solution you've provided me with in 2 days; very much appreciated.

I'm in the process of prepping a post for a new problem so if you're an Index/Match guru as well, watch for the new post!

Thanks again for your resolution to the current problem.

**KjBox** · Jun 17th 2017

Re: Loop to Check Results

You're welcome.

Loop to Check Results

Participate now!

Share

Users Viewing This Thread