Wow, Thank you so much for everything. I feel really silly. I will make sure to keep CASE and END 1:1. I will keep in mind what you said about taking a step back and maybe restructuring some stuff. I will mark something as a solution as soon as I can validate.
Thanks for the help. 1. Yup you got it 100% I am counting each unique instance. 2. This is more complicated. Full disclosure we are moving from one management system and need the cards to be flexible enough to use both data mappings. The data from both systems have overlapping terms. I was trying to ensure that nothing is…