Hi,

Is there a way to execute a formula on all rows of a column in excel?

Regards,

Shawn

Hi,

Is there a way to execute a formula on all rows of a column in excel?

Regards,

Shawn

hello @shawnmurray

use **write cell** or **write rang** Activity **inside Excel scope** to write your formula into excel

REgards

Ajay

@shawnmurray

**Source Range** —> location of excel cell having formula. (e.g. —> **“A1”**)

**Fill Range** —> The range you want to Autofill, including the cell having formula. (e.g. —> **“A1:A9”**) This field supports only strings and String variables.

take a look here, Auto Fill Range.zip (26.6 KB)

1 Like

@samir

Okay all that makes sense! Thank you

Where do i input the formula that i want to use?

Regards,

Shawn

Formula should be inserted in a excel cell, and that cell location you’ve to put in **Source Range**

Let’s take a example

here, A1 cell in excel has a **formula**, A2 to A9 cells are blank and you want A2 to A9 cells should follow same formula as A1, In this case you should pass that range including cell having formula, so here its **“A1:A9”** getting?

for your understanding I’d attached sample workflow in my previous post

Go through and you’ll get the idea.

1 Like

@samir

Okay so this is something I do manually in Excel Application before “Auto Fill Range” Activity?

Regards,

Shawn

hey @shawnmurray

but you can put the formula by using **Write Cell** too (in quotes), as shown in below shot.

and after the **write cell** activity you simply use **Auto Fill Range**

2 Likes

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