complex arrays

So I manage to create a dynamic range of dates with all the 1st of month between a period of time. What I want to do, is sum all the expenses of respective month from another table. That result should be another dynamic range of the same size as the one with the dates in order to create the...

I am looking for the advice of experienced Excel users regarding the "translation" of a web-based application into an Excel spreadsheet and really hope to get some useful input regarding this matter. Since year 2014 I've been working on a rather complex lottery prediction system. It is a...

Hi all, Thank you in advance for the help. I am looking to create a macro that will bring in all cells (A:X) for every row that's value in Column A is "BONDS". However "Bonds" appears in A column cells before the data appears but I want all the "BONDS" lines below the merged header (A:X) that...

Hi All, I originally posted a question here about Syllogisms (If A = B and B = C then A = C). Here is the Spreadsheet I need help with. !Please note that to reduce calculation time, I’ve removed all but a text version of most of the formulas, which can be found at the top of their respective...

Gurus I need a favor for the following. I need a macro which creates Dependency Density i.e., Input : A B C D Tot A - 4 0 0 4 B 1 - 1 0 2 C 3 1 - 1 5 D 1 0 1 - 2 To 5 5 2 1 Expected output : Denser part should come in right hand lower corner Output: C D A B Tot B 1 0 1...

I'm really hoping someone can help me...there doesn't seem to be an answer posted already on the internet and I wanted to consult the experts before giving up. I have created a formula that acheives my desired result, however, because it is so complex, it causes my data tables to take 30...