-
If you would like to post, please check out the MrExcel Message Board FAQ and click here to register.
If you forgot your password, you can reset your password.
complex arrays
-
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...- LottoMatic
- Thread
- complex arrays complex calculations complex conditionals expert opinion filter advance criteria lottery
- Replies: 2
- Forum: Excel Questions
-
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...- KJones97
- Thread
- cells complex arrays consolidate copy & paste row
- Replies: 6
- Forum: Excel Questions
-
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...- Danieljfern
- Thread
- alternatives array formulas complex arrays streamline syllogism
- Replies: 0
- Forum: Excel Questions
-
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...- sdjacob
- Thread
- complex arrays dependency matrix
- Replies: 0
- Forum: Excel Questions
-
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...- kethee
- Thread
- array loops complex arrays data tables slow multiple arrays sumproduct arrays
- Replies: 2
- Forum: Excel Questions
Some videos you may like
This Week's Hot Topics
-
Payment term and Cash flow (formula linked with costs)
- Started by Adfinance
- Replies: 43
Hi everyone, I need to calculate automatically the cash position (cashout) based on payment terms and costs. The payment terms may change, so I... -
Match to a list with wildcards
- Started by The Gent
- Replies: 29
Good day all, I am trying to do something which it my head feels quite simple but I can't get a result. I have four dimensions in a spreadsheet... -
Inserting text above first blank row then above third blank row etc.
- Started by Livin404
- Replies: 24
Greetings, I have a VBA where I'm trying to insert text into blank cells. On worksheet "Deficiencies" I have seven groups of ranges that I... -
code to get students marks from source sheet to destination sheet.
- Started by rzml
- Replies: 22
hi, I am looking for a VBA code that can get student marks using his ID and evaluation type (as headers) from source sheet to destination sheet. I... -
Run VBA on all open tabs
- Started by Dannottheman
- Replies: 22
Hi, I searched but could not find an answer to this. How can I make the 3 VBAs below run on all the open sheets/tabs in my Excel? Right now I... -
Functions to separate a string separated by commas
- Started by jeffdolton
- Replies: 22
Hi, I’ve opened up another thread as my request this time is a little different. With help from experts on this forum, and using some basic excel...