Please let me know if I'm being unclear? I feel like there MUST be a way to do this in Excel, but I can't seem to find anything on the topic.

I can try to mock up an example if that would be helpful.