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