Sort by filter excel?

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.

please guide me about it. @Hiba_B

Hi @fairymemay ,

Please take a look…

Regards
Balamurugan.S

@balupad14 How​ to​ condition​ in​ sorting?

Hi @fairymemay ,

Filter check this one…

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:


To have this result:
image

1 Like

@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)

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:


In the filter you have now a “StartsWith” :wink:

If the robot get one type that has not been specified, it disappears in the output. If you want a specific treatment for these values, let us know !

@Hiba_B If I don’t want specify name type because some time have more type but I want sort as below.

  1. alphabet R to Z
  2. alphabet A to Q
  3. Change Type
  4. New
  5. Change SIM

Any idea?

1 Like

This is a perfect explanation of your need !!
This will help me to do something better, I will let you know :wink:

@Hiba_B I​t​’s​ perfect​ explanation.
If​ sort​ by​ upper I​ show​ you.

  1. alphabet R to Z
  2. alphabet A to Q
  3. Change Type
  4. New
  5. Change SIM

I​ think​ it​ perfect.

Please​ guide​ me.

Hi @fairymemay !
Sorry for the delay, here is a suggestion:
Sort_with_queries.xaml (15.3 KB)
Don’t forget to modify the read and write range so it fits to your computer needs !

Let us know if it does not work as expected :wink:

Hi @jackyjoy123 !
Do you also need to filter with a specific rule of range letters ?
Or do you have a specific case in mind we might help you on ?