"Bob Phillips" wrote in message
...
The bit I can't get around is to array each cell to get the max
digit, then array down the rows. I have had at least 10 brilliant ideas so
far, all rubbish :-)

Been there; done that on other problems in the past, so I didn't waste much
time on that approach this time around. I don't think Excel can handle a
horizontal array and a vertical array in the same array formula in a
sequential manner.

Besides, I'm sure Harlan can come up with a solution using MMULT or some
such, but it's way beyond my limited capabilities!

Regards,

Vasant