How to get row index based on location?

Help Activities
,
21

Hi @JustZaffan

Check this xaml adapth it to your excel

BlankProcess5 - Copy (7).zip (4.1 KB)

cheers

22

Here is the dummy data

image

Dummy Data.xlsx (9.4 KB)

The task is to find the row index for row containing “2022”, “I.Dec” and “Line12”

23

Hi,

Can you try the following sample?

image
image1056×1297 35.3 KB

Sample20221208-9.zip (10.1 KB)

Regards,

24

Hi @JustZaffan

Did you happen to check the xaml i provided?

Are you facing any issues?

Cheers