Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved.
Learn more here!
I didn't look through the solutions, so I'm sure this was done before, but I used a trick I've used in SQL to do this. I parsed out the code range into a high and low, then appended the records and checked to see if they were between, if they were, I added a 'keep' flag and then filtered out all the NOs. Followed that with a summarize tool. And then to validate the results, I joined my results to the given results using the three key fields.