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

  • Thread starter Thread starter Guest
  • Start date Start date
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I get the diagonal of a matrix from excel? 6
Matrix Inversion by Gaussian Reduction 16
matrix function to do this? 2
Finding location (or start cell) of highest consecutive values 3
How can I do this ?? 5
Best 3 Consecutive Months 13
nXn matrix creation 7
Excel and consecutive number 2

Back
Top