regarding filter for text rows

[Thulasi]

hello,

I need to filter a set of text rows among many text rows. But not based on record id.

1	school
2	office
3	administration
4	pantry
5	terrace
6	development
7	design
8	function
9	tool
10	software

the below table shows an example that I need to filter. so here, I need to filter between terrace and tool based on the strings of the rows. as I tried and I can only filtered one row either terrace r tool but not in between rows.

Apologize me if I questioned anything wrong. Just to know, is this type of filtering is possible or not?

5	terrace
6	development
7	design
8	function
9	tool

Thanks,

Thulasi S

[Inactive User · Accepted solution]

Solution attached.

[Thulasi]

hii @Inactive User,

 Awesome!!!! that works perfectly, thanks for your response.

Thanks

Thulasi S

[Thulasi]

Hi @Inactive User,

I am pretty much happy with the previous solution u gave for my problem. But, I need a little modification in that, what if I have a same  set of rows following the previous set of rows. I need to filter it as follows.

1	school
2	office
3	administration
4	pantry
5	terrace
6	development
7	design
8	function
9	tool
10	software
11	ABC
12	DM
13	school
14	office
15	administration
16	pantry
17	terrace
18	development
19	design
20	function
21	tool
22	software

the resultant should be

5	terrace
6	development
7	design
8	function
9	tool

17	terrace
18	development
19	design
20	function
21	tool

so the middle unnecessary values should be filtered and same set of values in the same field is to be filtered. Give some idea on this.

Thanks and Regards,

Thulasi S

[haroon_sa · Accepted solution]

Hi @Thulasi

Take a look at my workflow. Filter tool is enough to solve your problem. Hope it helps.

[Thulasi]

Hi @haroon_sa 

Thank You Very much for the solution. It works for me.