# complex arrays

1. ### Excel expert advice needed

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...
2. ### Copy & Paste Different Range of Cells from 7 Sheets

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...
3. ### Help streamlining Alternatives (Syllogism) Matrix.

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...
4. ### Dependency Matrix / Dependency Density Creation

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...
5. ### Complex Array Loops Question...

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...

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back