# Dynamic Filter Formula w/criteria list

1. ## Dynamic Filter Formula w/criteria list

Hello,

I am trying to learn and implement some new formulas.

Lets say I have a raw data table that contains transaction data with 25+ columns of unique transaction information. One of those columns list the customer name/ID. I have a separate table that is a list of all customers determining their tax exempt status (Yes or No). My goal is to in a separate worksheet, use the filter function spilling only the rows where the customer name/ID = "Yes". I am struggling to put this into a formula. If there is another thread that answers this questions, please forgive me as I couldn't locate it.

Thanks,
Chris

2. ## Re: Dynamic Filter Formula w/criteria list

Please provide sample workbook it helps us to test formulas and have a better understanding of your specific requirements.

3. ## Re: Dynamic Filter Formula w/criteria list

Hi,
just worked this out from scratch (!).
you can use this formula:
``Please Login or Register  to view this content.``
Cheers
Erwin

4. ## Re: Dynamic Filter Formula w/criteria list

Using the new dynamic array formulas, here's a different take on a solution. I have changed the file that was attached to show multiple records per customer because I assumed that's what you are expecting (as RChad says, it would be better if you attached a mocked up file with expected results - please read the yellow banner at the top of this page).

Anyway, the nice thing about the new dynamic array formulas is that you enter one formula in one cell and the whole result appears (no copying formulas down or across). the formula would be:

This is entered in cell H3 of the attached.

5. ## Re: Dynamic Filter Formula w/criteria list

@Gregb11,
these functions are not available in Office 2016, I see in front of the formula's : _xlfn._xlws

Cheers
Erwin

6. ## Re: Dynamic Filter Formula w/criteria list

They're only available in 365 on the monthly channel.
But that is what the OP asked for, so suspect their profile is out of date.

7. ## Re: Dynamic Filter Formula w/criteria list

Hmm, I thought for sure I saw the OP was on Office 365, but maybe I got confused because he was asking about the new formulas, which are only available in O365. Oh wait, I think the confusion is that this forum section is called "Office 365", so I would expect the answer to be based on O365.

8. ## Re: Dynamic Filter Formula w/criteria list

Yep, my bad, I've overlooked that.

Cheers
Erwin

9. ## Re: Dynamic Filter Formula w/criteria list

Must admit I hadn't noticed this was in the Office 365 board.

There are currently 1 users browsing this thread. (0 members and 1 guests)