How to get row numbers after applying filter in excel

[gajendiran.subbarayalu]

Hi,
Can anyone help me on finding the highlighted numbers after applying the filter in an Excel sheet?

[Anil_G (Anil Gorthi)]

@gajendiran.subbarayalu

Use for each row in excel after the filter

CurrentRow.ByIndex(0).Address.Replace("A","")

and then use the formula to get the cell number from which you can get the number by removing A

cheers

[gajendiran.subbarayalu]

Thank you @Anil_G

that was really quick and helpful!

[gajendiran.subbarayalu]

Hi,
Can we get results in the below format
1,2,3,5

[Anil_G (Anil Gorthi)]

@gajendiran.subbarayalu

You can use assign inside for loop and append them together with comma or use a list and use append to l
Collection

Cheers

[gajendiran.subbarayalu]

Hi @Anil_G
Am in the learning phase of the language, can you please show me the syntax for executing the scenario?

[Anil_G (Anil Gorthi)]

@gajendiran.subbarayalu

Is the screenshot confusing? Or where you are facing problem can you let me know?

Which wcenario you want to execute?

Cheers

[gajendiran.subbarayalu]

@Anil_G
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
1
2
3
5

[Anil_G (Anil Gorthi)]

@gajendiran.subbarayalu

Okay

So create avariable of type string (str)

Now use if activity with IsNothing(str)

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

Cheers