Apr 08 2021 10:10 AM
Apr 08 2021 10:22 AM
As variant Power Query could work - query A, filter on Yes, return result to B.
Advanced Filter also could be an option.
Apr 08 2021 11:00 AM
Apr 08 2021 12:29 PM
You may start from this About Power Query in Excel - Excel (microsoft.com) . For step by step instructions it's better to use sample file, steps are very depend on how concrete data is organized.
Apr 09 2021 10:03 AM
Apr 10 2021 08:24 AM
Sorry, I don't know. It's better to start separate conversation with this question.