How could I skip empty rows and still apply the formula value to the last one and so on?

[pprin001 (Paolo70)]

Hello, community.
Please need help.
The workflow is in the sheet “Hoja2”

I’m thinking about a workflow where It replicates the formula until the end but when a row with empty values appears It stops so I need help with this to reach the last value without stopping.

This is an example image:

The desired output would still be applying the formula

Plus, I’m not sure why I’m getting #¿Nombre? despite I apply the correct formula inside the uipath file.

Help, please.

1 - Copy.xlsx (17.4 KB)
Main.xaml (10.8 KB)

[whitestar (Phyo)]

Try with Classic Excel Application Scope. it works fine

Or you need to select this option (whichever options you want to process) in the modern excel scope

Cheers