pari_patel
(Pal Patel)
1
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)}
1 Like
Karuna
(Karuna Devanagavi)
2
@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
(prasath S)
3
Hi @pari_patel
Please try this,
Ex:
-
Put the formula in “b2” cell as if(ab1=“”,)
-
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
prasath_S
(prasath S)
7
@pari_patel awesome please mark my answer as solution and close the thread so it may be useful to others in the future.
Thanks
system
(system)
Closed
8
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.