Hi ,
How can we calculate the average of 2 similar rows cells in Excel using UiPath
Suppose: I have an excel and its 2 rows first cells are similar and we want the average of 2 cells beside the first cells in different excel sheet.
Input:
Input Value
A1 23.9
A2 18.7
A1 24.9
A2 16.8
Output
A1 Avg(23.9,24.9)
A2 Avg(18.7, 16.8)