Welcome to the forums. Your question is good and clear, except for one thing - no attached workbook. Please see Posting a Perfect Question. The problem is that I find it so much easier to follow what you're explaining if I can look at it in the workbook as well - and I'm sure many other helpers do to - and it helps others who are learning from the discussion. If your data is sensitive, then create a mock up or try to replicate the situation using the SuperStore data.
I would be happy to have a look at it (use the 'Use advanced editor' button to attach it).