I wish I could do something about the merged cells, but I can't. They come to me this way from a client. If I un-merge them, it screws up the formatting for the whole file.

I have tried the formula that you have laid out, but it doesn't work, probably because of the cells being merged.

Thanks anyway!