Don,
Post the sheet, or a sample that's similar and I'll see what I can come with using a straight formulas. I prefer them over VBA or macros because they are cleaner. Some things require VBA, but you'd be surprised what formulas will do. I didn't respond earlier because I thought someone...