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" <[email protected]> wrote in message
news:[email protected]...
> show a set of diagonal values in a matrix as a set of consecutive values
> in a
> column.