Can a Formula be Executed on all rows of a column in excel?

Help
1

Hi,

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

Regards,
Shawn

2

hello @shawnmurray

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

REgards
Ajay

3

Hi @shawnmurray

I’ll suggest you to use Auto Fill Range activity

4

@Ajju And how would it know to pick up all rows?

Regards,
Shawn

5

Hi @samir

So would i put the formula in “Source Range” or “Fill Range”

Regards,
Shawn

6

@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
7

@samir
Okay all that makes sense! Thank you :slight_smile:

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

Regards,
Shawn

8

@shawnmurray

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. :slight_smile:

1 Like
9

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

Regards,
Shawn

11

hey @shawnmurray

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

aa
and after the write cell activity you simply use Auto Fill Range
:slight_smile:

2 Likes
12

@samir

hey,

Thats even better! Perfect!

Thanks,
Shawn

1 Like
13

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