filter function with multiple criteria

  1. Z

    Count Distinct Values in Un-Filtered Table across Multiple Columns with 1 Criteria

    Hello @Fluff, This is a follow-up question regarding my earlier thread here, using your following formula: =LET(a,REDUCE("",t_MUs[[Theme A]:[Theme C]],LAMBDA(x,y,VSTACK(x,IF(SUBTOTAL(103,y),y,"")))),ROWS(UNIQUE(FILTER(a,a<>"")))) The filtered results are working great. However, I wanted to...
    • zero269
    • Thread
    • distinct count filter function with multiple criteria unique function
    • Replies: 0
    • Forum: Excel Questions
  2. D

    FILTER function looking at duration and time

    Hello, I'm trying to modify a filter function I'm already using and have no idea where to start. Right now I have a very large data set and the filter function is looking for all occurrences >23hrs. What I'm trying to find now is all instances where a person has >23hrs over a 26hr time span. I...
  3. Z

    Populate a list with specific fields using Filter function

    Hello everyone, I have below table that can populate employee names using filter function, what I need to add is populating specific fields (like country and full time/part time fields) along with employee names. Is there anyway that I can do that using the same filter formula but adding more...
    • zinah
    • Thread
    • filter function with multiple criteria
    • Replies: 10
    • Forum: Excel Questions
  4. N

    Apply 2 filters in the same column with filter formula

    I am trying to apply 2 filters to the same column, but I am unable to. I tried doing something like this: =FILTER(A:A,AND(A:A="Honduras",A:A="Nicaragua")) =FILTER(A:A,AND(A:A="Honduras")*(A:A="Nicaragua")) and none of them worked. Any help will be greatly appreciated. What I would like to do is...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top