Filter function in Office 365 - filter with designated field

Dear all


I wonder if there is a way to apply the apply the above Filter function -=FILTER(array,include) to filter selected field

In the normal version, in Advance filter, we can make our own filter field.

can the above do that too.

Eric
,

The short answer is, Yes

Dear Fluff

Can you share with me how ?

As I have a table of 30 fields, and I want to use this filter function to filter the fields for different people.

Thanks and look forward to it

Eric

Can you supply a workbook, showing data & expected results?

Also are you using 2010 as per your profile, or 365?

Dear Fluff

I have the attached and explained

Additional

I want to know who I can filter with Between dates

thanks

Thanks for that, how about
=FILTER(Summary[#All],Summary[[#All],[Check_In]]=B2)

Dear Fluff

Thanks but i want to filter the data that i need

One few field not all.

Eric

I don't understand, that formula gives exactly the same result as you showed.

Fluff

Yes, but i want to filter not the full field

But just a selection of fields

For example : I just want to filter the field below not Äll

1. Code
2. Nature
3. Name
4. Check_In
5. Check_Ou

t


Eric

Next time you are asked to provide expected results, it would help if you did just that, rather than supplying what you DON'T want.
Try
=FILTER(FILTER(Summary,Summary[Check_In]=B2),ISNUMBER(MATCH(Summary[#Headers],A10:P10,0)))
If this is not what you want, then supply a new file with exactly what you want.

For you other thread you can use
=FILTER(FILTER(Summary,Summary[Check_In]=B7),ISNUMBER(MATCH(Summary[#Headers],A16:E16,0)))