How to get row index based on location?

Hi @anon54733438

Check this xaml adapth it to your excel

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

cheers

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”

Hi,

Can you try the following sample?

Sample20221208-9.zip (10.1 KB)

Regards,

Hi @anon54733438

Did you happen to check the xaml i provided?

Are you facing any issues?

Cheers