Can anyone help me on finding the highlighted numbers after applying the filter in an Excel sheet?
Use for each row in excel after the filter
and then use the formula to get the cell number from which you can get the number by removing A
Thank you @Anil_G
that was really quick and helpful!
Can we get results in the below format
You can use assign inside for loop and append them together with comma or use a list and use append to l
Am in the learning phase of the language, can you please show me the syntax for executing the scenario?
Is the screenshot confusing? Or where you are facing problem can you let me know?
Which wcenario you want to execute?
your screenshot is perfect.
But I need to write my result as 1,2,3,5,8 into a single cell,
instead of putting them on multiple rows like below
So create avariable of type string (str)
Now use if activity with
On then side
str = CurrentRow.ByIndex(0).Address.Replace("A","")
On else side
str = str + "," + CurrentRow.ByIndex(0).Address.Replace("A","")
After loop you will get as needed
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.