New Filter Function in 365 -

[Eric Tsang]

Dear all

I am trying the new filter function , =filter(array,include)

The data source is a table of 19 fields but now i need only 4 fields


Code
1 Nature
2 Combine
3 Name
4 Check_In
5 Check_Out
6 Blocked
7 Nite
8 Rooms Materialized
9 Twin
10 DBL
11 Sgl
12 Tpl
13 Pax
14 Twin-Shared
15 Sgl_Sup
16 Xbed
17 MainGroup
18 Tours
19 Tour_Date

Now only need the following fields
1 Nature
2 Combine
3 Name
4 Check_In
5 Check_Out

I wonder how i can do it , i know for advance filter, we can, see the Youtube: https://youtu.be/evrnIuDRtsQ @ 5.58 mins
Appreciated your help

Eric

[KOKOSEK]

I am not sure that yor data is in 1 column.
But if:

	A	B
1	1 Nature	1 Nature
2	2 Combine	2 Combine
3	3 Name	3 Name
4	4 Check_In	4 Check_In
5	5 Check_Out	5 Check_Out
6	6 Blocked
7	7 Nite
8	8 Rooms Materialized
9	9 Twin
10	10 DBL
11	11 Sgl
12	12 Tpl
13	13 Pax
14	14 Twin-Shared
15	15 Sgl_Sup
16	16 Xbed
17	17 MainGroup
18	18 Tours
19	19 Tour_Date

	A	B
1	1 Nature	=FILTER(A1:A19,LEFT(A1:A19,FIND(" ",A1:A19)-1)*1<=5)
2	2 Combine	2 Combine
3	3 Name	3 Name
4	4 Check_In	4 Check_In
5	5 Check_Out	5 Check_Out

[Eric Tsang]

Dear KoKosek

Thanks, my apology


Please see my excel attachment

Eric

[Fluff13]

You can do that the same way as I showed you here https://www.excelforum.com/excel-for...ml#post5302012

[AliGW]

Administrative Note:

Unfortunately, this is a duplicate thread, and you are allowed only ONE thread per issue here.

Please see Forum Rule #5 about thread duplication.

I am closing this thread, but you may continue here in the original thread: https://www.excelforum.com/excel-for...ted-field.html