[Screenshot 2022-11-16 090034] I am trying to get the bank name with the lowest value from vs BNM (Buy) and put it into the To Buy, may I know how can I do this using UI path?

HI, Can you try the following expression? dt.AsEnumerable.Where(Function(r)r("Bank").ToString<>"BNM").OrderBy(Function(r) Double.Parse(r("vs BNM (Buy)").ToString)).ToArray() Regards,

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

Help StudioX

Yoichi (Yoichi) November 16, 2022, 5:35am 9

Hi,

As the table starts from B4, it’s necessary to set the following In ReadRange?

Excel.Sheet("Sheet1").Range("B4")

 Excel.Sheet("Sheet1").Range("B4:G9")

Regards,

Topic		Replies	Views
How to get the Max and Min value from excel and write it to another excel Activities datatable , excel , activities , question	12	3401	March 10, 2022
Calculate the lowest excel value Help datatable , excel , studio , error	4	1233	October 26, 2019
How to find max and min price in the table with linQ method? Studio datatable , studio , question , tools	22	1169	July 21, 2023
Data-table issue - select max value and choose different column value Activities excel , activities , question	3	1795	February 17, 2021
Datatable doubt Studio studio , question , workflow_diff	25	1675	June 11, 2022

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

Related topics