Help with Unique filter formula

[DoormatFluke]

Hello Excel Forum Members,

I am having trouble creating a unique filter formula that filters on multiple criteria. An example of how my data is set up and the formula I am using is attached. A picture of my data is is provided below.

Picture 4.png

Can someone please help me with this problem?

Thank you for your time.

[alansidman]

1. Instead of showing us formula that does not work, why not explain in simple English what you are trying to do. Explain your criteria and we will attempt to resolve your issue.
2. You are using formulas that are not part of Excel 2010 which is what you have listed in your profile. Please update your profile to reflect the actual version of excel you are using.

[TMS]

I think this is what you need:

Please Login or Register  to view this content.

[wk9128]

Cell D27 formula

Please Login or Register  to view this content.

[DoormatFluke]

Trevor,

I appreciate the effort but the formula you provided returns all unique job numbers with any one of the three product codes associated with it. I need a formula that returns only the job numbers that contain all three 3 of the product codes selected.

Thanks anyway.

[DoormatFluke]

wk9128,

Thank you for reviewing my request and providing a possible solution.

Unfortunately, the formula you provided returns all of the job numbers with any one of the three product codes associated with it. I need a formula that returns only the job numbers that contain all three product codes selected. In the example I provided, there are only two job numbers that contain all three product codes (2006 and 2107).

Thanks anyway for the attempt. I really appreciate your time.

[windknife]

One way, try this in D19.

Please Login or Register  to view this content.

[DoormatFluke]

Windknife,

Thank you for taking the time to help me with my formula problem. It was a very impressive approach. Unfortunately, I went with another, less-refined solution. The info you provided was above my Excel experience level.

Thanks again. I really appreciate your time.

[windknife]

It's OK, as long as the problem is solved