Multiply cells efficiently

One Response to “Multiply cells efficiently”

  1. Alex Groberman says:

    If I understand the question correctly, this function would work:

    =INDEX(Table1,INT((ROW()-1)/ROWS(Table1)+1),COLUMN())*INDEX(Table1,MOD(ROW()-1,ROWS(Table1))+1,COLUMN())
    

    First you would put your original 500 rows in a table somewhere ("Table1"), and then enter this function as an array (ctrl-shift-enter) starting in cell A1, with seven columns and 250,000 rows. It can be adapted with subtraction from row() and column() if you wish to put your data in a location other than cell A1.

    -Alex

Leave a Reply

How to add vba code to your comment:
[vb 1="vbnet" language=","]
your code
[/vb]

How to add a picture to your comment:
Upload picture to postimage.org
Add picture link to comment.

How to upload a file
Upload file

Resize a range of values

Leave a Reply

How to add vba code to your comment:
[vb 1="vbnet" language=","]
your code
[/vb]

How to add a picture to your comment:
Upload picture to postimage.org
Add picture link to comment.

How to upload a file
Upload file

Website statistics for 2015

2 Responses to “Website statistics for 2015”

  1. Chris Macro says:

    Congratulations on the continued success of your blog, Oscar! Hoping 2016 builds on your success and I'm looking forward to what you have in store for us this year!!

Leave a Reply

How to add vba code to your comment:
[vb 1="vbnet" language=","]
your code
[/vb]

How to add a picture to your comment:
Upload picture to postimage.org
Add picture link to comment.

How to upload a file
Upload file

Follow stock market trends – trailing stop

Leave a Reply

How to add vba code to your comment:
[vb 1="vbnet" language=","]
your code
[/vb]

How to add a picture to your comment:
Upload picture to postimage.org
Add picture link to comment.

How to upload a file
Upload file

Follow stock market trends – Moving Average

One Response to “Follow stock market trends – Moving Average”

Leave a Reply

How to add vba code to your comment:
[vb 1="vbnet" language=","]
your code
[/vb]

How to add a picture to your comment:
Upload picture to postimage.org
Add picture link to comment.

How to upload a file
Upload file