Excel Filter List Based on Another List | Formula and Advanced Filter Solutions

Hi Chester, thank you for the video, very useful. Is there a way to Filter only customers that have certain products. E.g Customer 1 has Product A & B, Customer 2 has product A & B but Customer 3 has product A, B & C, I want a list of customer that only have Product A & B. Any guidance would be useful. Thanks, Steve

you've saved my life

Hi. theres any video of dependent lists based on id columns instead of header columns? Meaning I got A columns with the id and b column (categoryid and category name) with the display text, and another table with the id and let's say productid and product name. that could be helpful. Thanks in advanced

Thank you very much for this tutorial, it helps me a lot!

You could just use x lookup and hide na's

Excellent! But can we retain all the Filtered rows as well as showing the Subtotals - rather like an expanded subtotal table using the old Data/Subtotal function?

I am trying to create a Consolidated invoice (Brexit!) that shows all the stock items sorted by and sub-totaled (for weight for example) by Country of Origin.

Very helpful!!!. How to filter data if the list of value are string pattern. For e.g. List of values are ABC, JKL etc, how to do string pattern match in PROD ID column. Thanks in advance!!!

Already subscribed from the first tutorial. Valuable lesson as always. Thumbs up from the beginning class so that I won't forget. Thanks a lot for your teaching ! 👍

Very clever, however it would be so much easier to do in SQL

Exactly what I worked on today, but a little more circumstantial. I have a list of names where some names have a cross in the next column. I want to add these names to a new list. This should be useful for me. Thank you for being so educational.

Very helpful, thanks a lot

For those using advanced filter, you can create a macro while using the advanced filter and create a button assigning that macro.

Now whenever you make a change into the base data, you need to just click the button and it will do the job for you.

The FILTER function is a real genius created by Microsoft. Thank you Chester!!!