Write Formula till last last row in the excel

Hello Team,

Can anyone help me how to write formula =K2 - INT(K2) on Cell L2 and drag it to last row of data.

Regards,
Anantha

@Anantha_Krishna - Welcome to the community…

Are you trying this is in Studio or StudioX?

StudioX

@Anantha_Krishna - Here you go…

My Input Sheet…

image

Workflow…

Output

image

Hope this helps…

Thanks for your support Prasanth.

Can i get another help, to delete only visible rows.

As i have tried with delete rows with selecting All visible rows, but first time it is deleting and same for second time it is not deleting rows.

image

Looks like this is a different question than what you originally posted, so I would suggest you to close this topic( my marking pertinent post as solution) and open up a new forum post.

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.