 $counter$ variable within an Excel Loop to determine Excel row
I'm trying to do the following:
Start Loop "Each row in an Excel dataset of Session=Default"
If $Excel Column(1)$ includes "blah blah" then
Variable Operation: $Counter$-1 To $variableX$
Excel: Get value of cell "A$variableX$" and assign to variable "variableY"
End If
End Loop
My goal is to retrieve the value of the cell ABOVE the current loop instance and assign it to "variableY".
However, I keep on getting an error that I need to specify a proper cell, so it seems $counter$ is not working properly in this instance.
Any ideas?
|