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