How to apply the below formula to the entire column

Hi Team,

Kindly find the below screenshot FYR

How do i apply the above formula to the entire column

hi,

kindly check this post

Regards

Hi Thanks for your reply but type into is not giving proper solution please find the below screenshot FYR, it is just copying the same to entire Colum

Hello @bhanu.priya2 ,

You can use Fill Range activity to achieve the same. Check the below doc.

download this custom activity and use drag formulas activity

Please help,

I have an Excel file “Excel Template” that I want to fill out

  1. Column A8 : C1000 will be filled with data from CSV that I have in the CSV folder
  2. Columns E1:K10 will be filled with images that I have in the Image folder
  3. Column E12 : K20 will be filled with a circle pivot graph obtained from the data in column A8:C100

Once finished it will be saved in a folder and given a name according to Excel “ListAccount” in the “Subaccount” column

The “Excel Template” file will loop according to the data in the “LisAccount” file

How to create a project like the flow above, so that the “Excel Template” file can run well?
ListAccount.xlsx (9.3 KB)
Excel Template.xlsx (10.3 KB)