Hi,

I want to calculate the average of similar rows and write it into different excel sheet.

Please help

find the rows counts,then calculate average based on the average values set the range in excel read and write range to read and write excel

pls share xaml…its urgent

but it is Writing the common name values in sheet2 name column.

I want it only once after calculating average of similar rows.

in your excel there are two excel columns but in mine there are 3…name,number and date…

BOT is Writing average value in date column of sheet 2…it should write in 4rd column of sheet2…i.e. average column

Hi,

its working fine for giving average velues but its giving date in wrong way…it should be 2018/07/15 but it’s giving as 2018/00/15

is it beacuse few dates are written as 2018-07-15 and few as 2018/07/15 in sheet1?

if this is the case then how can we rectify it??

@somya177 try below code. In formats array variable add all formats which are present in your excel sheet code will work.

Main.xaml (20.1 KB)

it is giving date as 01/01/0001…it is supposed to give 2018-07-15

yes in mm/dd/yyyy

yes…

Hi @Manjuts90,

below is the format variable of variable type- string

and Default- {“MM/dd/yyyy”,“dd/MM/yyyy”,“yyyy-mm-dd”}