How to get the name for a maximum or minimum value from a table

Help StudioX
,
2

@hjie30
Welcome to UiPath Community.
Read the excel and store it in datatable
minVal = dtFiltered.AsEnumerable.Min(Function (x) CDbl(x(“vsBNM(Buy)”).toString.Trim))
maxVal= dtFiltered.AsEnumerable.Max(Function (y) CDbl(y(“vs BNM(Buy)”).toString.Trim))

Write max value or min value in the respective cell in excel.

1 Like