Our company has approximately 10 product groups. Each customer normally has between 3 and 5 of these groups. I have created a sheet that shows each customer's revenue by product. What I am attempting to do is create a filter that will allow the user to find customers that have at least x number of product A, but do not have product B. I need to be able to split up the total revenue filter into revenue filter for each product. Thanks
Can you post a packaged workbook that demonstrates the problem, and what you are expecting as a result?