Get Top 5 Highest Number from workbook Sheet Without Excel Scoop Activity

I want to Extract top 5 highest digits From Sheet
eg.
12
13
0
9
6
42
42
1
7

Output
42
42
13
12
9

Thank You…

Hy @IK5295

Populate the data into a data table
Use the sort data table activity
Use a while loop to add the first five items to a new data table
Print this data table to excel

Is it clear for you?
Regards

1 Like

Thank you I am trying this and let you know …

@William_Blech_Sister Thank You For Your Solution keep Supporting Developers.

1 Like

Hy @IK5295,

Glad I could help!! Happy automation!!!

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