complex arrays

  1. LottoMatic

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

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

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

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

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

This Week's Hot Topics

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Top