show a set of diagonal values in a matrix as a set of consecutive.
 

show a set of diagonal values in a matrix as a set of consecutive values in a
column.

Hi Kelvin

no idea what you mean, could you please explain in a bit more detail i.e.
i have
........A.........B.........C.............D
1.....10....................................
2...............20..........................
3............................30.............
4...........................................40

and i want

........A.........B......C..............D......... .E
1.....10.......................................... ..10
2...............20................................ ..20
3........................30....................... ..30
4..........................................40..... ..40

if so then in column E you could use a formula such as
=SUM(A1:D1) and then fill down ...

Cheers
JulieD

"Kelvin" wrote in message
...
show a set of diagonal values in a matrix as a set of consecutive values
in a
column.