Increment CellNumber within Excel Formula

[pari_patel (Pal Patel)]

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)}

[Karuna (Karuna Devanagavi)]

@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

[prasath_S]

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

How to Autofill the whole column in excel file UiPath - RPA Learners

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

[pari_patel (Pal Patel)]

thanks

[prasath_S]

Hi @pari_patel

Is the issue resolved?

Thanks

[pari_patel (Pal Patel)]

yes.

[prasath_S]

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

Thanks