Find solution
What do temporal and spatial summations have in common?

In Microsoft Excel, do I need to run a macro in order to execute 2,500 summations of two sets of numbers?

  • In Excel, I have 2 columns of 50 random values (numbers). I need each number from each column to be added to each other once. That's a total of 2,500 summations of the two numbers. Do I need to run a macro? I'm not new to Excel, so any help here would be appreciated.

  • Answer:

    Say you have two columns, A and B, each with 50 numbers. Copy and Paste Transpose the numbers from column B across the top row so that you now have a grid. You'll have numbers in column A from row 2-51. You'll have numbers in Row 1 from B-AY forming the borders of a grid. In B2 you will want a formula like =$A2 + B$1 copy that all the way right and then fill that down. The resulting grid is the answer.

Quora User at Quora Visit the source

Was this solution helpful to you?

Other answers

Wouldn't MS Access be a better and a quicker bet?

Amit Sarda

This should work: =OFFSET($A$1,ROUNDDOWN((ROW(A1)-1)/50,0),0)+OFFSET($B$1,MOD(ROW(A1)-1,50),0) This assumes you've got 50 values in A1:A50 and 50 values in B1:B50. You can copy this formula down from D1:D2500 (or whatever column you want, really) and get your results.

Michael Flynn

Related Q & A:

Just Added Q & A:

Find solution

For every problem there is a solution! Proved by Solucija.

  • Got an issue and looking for advice?

  • Ask Solucija to search every corner of the Web for help.

  • Get workable solutions and helpful tips in a moment.

Just ask Solucija about an issue you face and immediately get a list of ready solutions, answers and tips from other Internet users. We always provide the most suitable and complete answer to your question at the top, along with a few good alternatives below.