Loop Through Text and Test for Scenarios Q
Below is the only part I am having issues with, it shows as <blank in Col H
myStr = IIf(myArr(i) = "GLS" And IsNumeric(Mid(c, 5, 6)) And _
IsNumeric(Mid(c, 12, 8)), "Duty Exceeded", "")
The actual value in Col C for above would look like "GLS 123456 78901234" and it would have <0 in Col D and 0 in Col E
|