Findout Highest value to lowest value ( Descending order ) in excel

Hi Everyone, I have a small doubt in excel. I have a excel data in that i need to find out which is big value and i need to give rank based on that. I’m attaching my excel sheet below for reference in that i have given input and output.

i want any suggestion except SortDataTable . I don’t want to re arrange the data. i need to update value based on big value.

Excel Task.xlsx (9.9 KB)

Hi @Learner007

Checkout this workflow
RankSelection.xaml (12.5 KB)
Excel Task.xlsx (9.9 KB)

Hope it Helps


Thanks @Sudharsan_Ka , it is working.

Great @Learner007

Happy Automation!!


@Sudharsan_Ka i have a small doubt after IF condition you are not storing them anywhere how it is storing into data table in final. I’m just little bit confused there.

So in these activities i am storing the data straight in the datatable @Learner007

it will be updated in the datatable in the backgroud and after updating if you write the datatable in the excel file the updated items can be seen there

Row(1) → is nothing but Row(“Value”)

ok got it, Thanks for the clarification @Sudharsan_Ka

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.