Nigel,
Again, thank you for your time on this. UNfortunately, once I expand the ranges beyond the current data set, your formula bombs. IN the spreadsheet I sent you, expand the range to 10:16 and you get #VALUE error. I've got my spread sheet set to 1500 rows of information because this will be used week to week with varying amounts of data.