Ladies and Gentleman I am at a dilemma I am trying to find out a way to filter out certain data in a column field I have an idea on how to do this but I do not know the correct syntax to use. First here is the table and here is the code structure I would like to write.
First Name Last Name First Match Second Match James Matheson 0 2 Monroe Labonson 4 3 Barack Obama 2 5 Frederick Douglas 3 4 Steve MCGowan 1 1 John Seals 15 15 Mike Omalley 14 15
for i= 1 to length of column First Match
for j=1 to length of column Second Match
If value of the data in column First Match = 15 OR value of the data in column First Match = 1 AND value of the data in column Second Match = 15 OR value of the data in column Second Match = 1 Then
Filter the data and append so the filtered datas are saved for both First Match and Second Match
end if
next
next
Is my method correct?