Average of a column without min and max

[Krishna_Raj]

@Ionut_Frincu

How to get the Max and Min value from excel and write it to another excel

Hi @Krystal , For the Input data provided, the Output Should be the Min and Max Value rows. So In short, the Output should contain only two rows. For this You can follow the Below Steps. You have the Datatable read using Read Range Workbook Activity, let’s say having the datatable variable named DT.(Without Add Headers) You can then create a Clone of this DT, with variable say cloneDT. Clone can be achieved as below using Assign Activity : cloneDT = DT.Clone Next, We can use two Add Dat…

check it for reference