How to select columns in the excel

How to select columns from a-f in the excel do the formula ->name manger

  1. I’ve to select the A-F column regarding the range in the column A
  2. select A-F and go to formulas in excel and click on the name manager

Can someone suggest how can this be done

Hi @sreelakshmivella2012

Can you share some screenshot for better understanding?
Also add some more info to your issue

Thanks,
Srini

Thankyou for the reply
My query is
I’ve an excel file where

  1. I need to find the age between 20-30 in the particular column (eg: if age is in column C)
  2. need to select the data from column c which has which has age 20-30 and select the data till column G for the data of 20-30 of age , like this the loop should repeat for the next 20-30
    SS1error

and then do the formula

@sreelakshmivella2012

Why don’t you use ReadRange activity and store that into an datatable variable
Now use Filter Datatable activity to specify you condition
Then you can write your results to another excel sheet using write range activity

Hope this may help you

Thanks,
Srini

Hi @sreelakshmivella2012
In Filter Data Table activity give filter condition as

Regards,

i shouldn’t write it into the different excel ,i need to do this activity while excel is open perform the if condition regarding age and if the got selected then need seleall the columns data that comes under age , click on formula tab and do the name manager

i tried this , it did filter out the age but didn’t select the data like

  1. if age 20-30 got filtered it need to select all the data from column c-g which comes under age 20-30 and then click on formulas option in the excel and do remaining

@sreelakshmivella2012
In Output Columns you have to give the required columns to output excel
image

I hope it helps!!