Increment CellNumber within Excel Formula

Need help to solve Excel cell increment in formula.

I have excel containing formulas which I am using in different excel to put those formulas for each column.

Que: Two formulas have cell umber which is incrementing by row.

Ex: {=IF(…,AB1)}
{=IF(…,AB2)}
{=IF(…,AB3)}

@pari_patel
Try this

Change the “Write Cell” activity “Range” as per your need like “B”+Counter.ToString or C+Counter.ToString or D+Counter.ToString … columns

Hi @pari_patel

Please try this,

Ex:

  1. Put the formula in “b2” cell as if(ab1="",)

  2. Use autofill range activity and give source range as “b2” and destination range as “b2:b100” for filling to 100 rows.

Refer the below link also

For dynamically find out the last row,

Read the excel sheet data in the datatable variable name dt.

And in auto fill activity give range as “b2:b” + dt.rows.count.tostring

Thanks

1 Like

thanks

Hi @pari_patel

Is the issue resolved?

Thanks

yes.

@pari_patel awesome please mark my answer as solution and close the thread so it may be useful to others in the future.

Thanks

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