I want sort type by condition as below (now sort type by A-Z). data.xlsx (11.7 KB) step 1 Bring row change type before new type step 2. Bring row change sim type after fore new type step 3 Bring type after change sim type until end row to first row. [image] please guide me about it. @Hiba_B …

Hi @fairymemay , Please take a look… [image] Excel sorting by similar name Academy Feedback Hi @Veda_Ashrita , Here is activity called “Sorting” . It has options to sort multiple columns. Video demonstration. [UiPath Sorting multiple columns|Sort Excel |Excel…

@balupad14 How to condition in sorting?

Hi @fairymemay , Filter check this one… [image] Filtering Excel Column Help Hi , Take a look this one. Add the filter condition here. [image] Regards Balamurugan.S Regards Balamurugan.S

Hi @fairymemay ! Sure, here is a suggestion: Sort_specific_order_one_column.xaml (12.1 KB) As it relies on a specific order that has a business logic, you can whenever you want change the order here: [image] To have this result: [image]

@Hiba_B @prasath17 From output your flow. [image] I want to move red text to top row (row2) Step filter as below. data filter.xlsx (11.4 KB) [image] Please guide me more.

@fairymemay - you are looking for custom sort …where first Reconnect, then Re New and then Suspend is that right?

@prasath17 yes, Reconnect, then Re New and then Suspend ( sort alphabet R to Z to first).

@fairymemay - @Hiba_B has already provided the solution…isn’t it?

Hi @fairymemay Sorry for the wait, here is a suggestion: Sort_specific_order_one_column.xaml (9.7 KB) As you have a very specific column order, you will have to specify each type of them, like the following: [image] In the filter you have now a “StartsWith” :wink: If the robot get one type th…

@Hiba_B If I don’t want specify name type because some time have more type but I want sort as below. alphabet R to Z alphabet A to Q Change Type New Change SIM Any idea?

Sort by filter excel?

Help Activities

balupad14 (Balamurugan (BalaReva)) May 10, 2021, 12:26pm 6

Hi @fairymemay ,

Filter check this one…

Regards
Balamurugan.S

Topic		Replies	Views
Sort excel? Activities excel , activities , question	0	716	May 10, 2021
Sorting data in Excel Help excel , activities , question	11	5815	December 25, 2019
Excel sorting by similar name Academy Feedback excel , studio , question	5	1679	June 30, 2020
Do the sorting column A(Account Number) – BM(Custom Data 34) – (recon report that we renamed) based on Column AQ (“Custom Data 12”) Forum question	3	77	July 10, 2026
Sorting columns in excel Studio datatable , excel , studio , question , workflow_diff	2	799	January 24, 2024

Sort by filter excel?

Related topics