Thank you, Max. This general method worked very well. My actual spreadsheet
is more complicated than the example I originally gave, but I eventually got
it all to work like I wanted using all the suggestions you gave.

Thanks again!