$counter$ variable within an Excel Loop to determine Excel row

[trentonponder]

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?

[forumsupport]

Hello,

Inside loop, you can store the current cell value in any user variable and can use it as previous cell value in next iteration of loop. We have attached a sample task for your reference. To run this task,
. Please copy attached .atmn under location, 'C:\...\My Documents\Automation Anywhere\Automation Anywhere\My Tasks' folder.
. Copy .xls under C:\.

Hope that helps.

[trentonponder]

Originally Posted by forumsupport

Hello,

Inside loop, you can store the current cell value in any user variable and can use it as previous cell value in next iteration of loop. We have attached a sample task for your reference. To run this task,
. Please copy attached .atmn under location, 'C:\...\My Documents\Automation Anywhere\Automation Anywhere\My Tasks' folder.
. Copy .xls under C:\.

Hope that helps.

Thanks, works perfectly!