Diagonal Matrix Fill
I hope I am obeying the ethics. I had an instant response to filling blank cells in an array. Thanks
Next problem - I have an array (say 20x 25) and want to paste column data, firstly in top left cell, then next column (same data) but down one row until the arrary is complete ie final column. Typically the data to paste is up to 6 to 8 rows.
Fine on the ethics, but I don't understand your question -- an example would help.
And where are you pasting the data from?
Entia non sunt multiplicanda sine necessitate
I want to paste the data from A6:A8 into the matrix (7x5) at C5 with the offset of one row down per column and finish withhin the matrix array as illustrated. I already have a solution to the fill with zeros
Thanks
Are you looking for formulae or VBA ?
eg Formulae
the above will also populate your 0's at the same time
Please Login or Register to view this content.
Last edited by DonkeyOte; 09-05-2009 at 02:52 AM.
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
Should have added, for 2nd Matrix you can avoid using TRANSPOSE Array and again use INDEX which will be quicker... eg:
Is that what you were looking for ?Please Login or Register to view this content.
Thank you DonkeyOte
VBA I think
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks