Oh and then you have another column that adds the MAX()'s up or you could do that in the same forumular ie :


= MAX(A1:C1) + MAX(D1:E1) + MAX(F1:F1) + MAX(G1:I1)

or howver it corresponds to what you need to max.

Good luck.