Thanks Andy. I never solved my problem (with Excel at least). I had already Hidden empty cells as gap and I used the iferror equation you listed. But alas, I had to get it off of my desk and into the hands of the other unsolvable problem, my boss.
Thanks again Andy.
Bookmarks