I have one scenario, in which I am scrapping data from NSE Live website. The data scrapping is done from table from website and storing in excel value. I want to get text value of column1 corresponding to highest value of column 2 of excel using Uipath.
For example the highest value of column 2 is -: 12345.56, So I want to get text value from column 1 which is Symbol name corresponding to that column 2 value which is LTP column
Please anyone help me out with this issue on urgent basis.
I am attaching screenshot and scrapped excel file.
Sorry I cannot share the code with anyone due to privacy issue.
NSE_Data_06012021_0343.xlsx (8.3 KB)