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
Regards
Sudharsan
Thanks @Sudharsan_Ka , it is working.
@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
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.
