Ask me your Excel, Macro, VBA Questions

[gokool]

I'm feeling generous.
Lets see how many folks I can liberate from Spreadsheet hell....

 

[Ancalagon]

Why did Satan invent VBA?

 

[scudsucker]

I need to edit this formula, because one of the calculations is wrong. Could you have a look?

=(((SUM(INDIRECT("'SIM Pivot'!B" & (MATCH(C34, 'SIM Pivot'!B:B) + MATCH($A35, 'SIM Pivot'!$A:$A, 0) - 2)), INDIRECT("'SIM Pivot'!B" & (MATCH(C34, 'SIM Pivot'!B:B) + MATCH($A35, 'SIM Pivot'!$A:$A, 0) - 2) - (1 * ((COUNTA('SIM Pivot'!$A:$A) - 2) / (COUNTA('SIM Pivot'!$A:$A) - COUNTA('SIM Pivot'!$B:$B))))), INDIRECT("'SIM Pivot'!B" & (MATCH(C34, 'SIM Pivot'!$A:$A) + MATCH($A35, 'SIM Pivot'!$A:$A, 0) - 2) - (2 * ((COUNTA('SIM Pivot'!$A:$A) - 2) / (COUNTA('SIM Pivot'!$A:$A) - COUNTA('SIM Pivot'!$B:$B))))))/SUM(INDIRECT("'SIM Pivot'!B" & (MATCH(C34, 'SIM Pivot'!$A:$A) + MATCH("Industry", 'SIM Pivot'!$A:$A, 0) - 2)), INDIRECT("'SIM Pivot'!B" & (MATCH(C34, 'SIM Pivot'!$A:$A) + MATCH("Industry", 'SIM Pivot'!$A:$A, 0) - 2) - (1 * ((COUNTA('SIM Pivot'!$A:$A) - 2) / (COUNTA('SIM Pivot'!$A:$A) - COUNTA('SIM Pivot'!$B:$B))))), INDIRECT("'SIM Pivot'!B" & (MATCH(C34, 'SIM Pivot'!$A:$A) + MATCH("Industry", 'SIM Pivot'!$A:$A, 0) - 2) - (2 * ((COUNTA('SIM Pivot'!$A:$A) - 2) / (COUNTA('SIM Pivot'!$A:$A) - COUNTA('SIM Pivot'!$B:$B))))))) * Weights!$C$13) + ((AVERAGE((INDIRECT("'SIM Pivot'!C"&(MATCH(D34,'SIM Pivot'!$A:$A)-1)+(MATCH($A35,'SIM Pivot'!$A:$A,0)-1)))/((INDIRECT("'SIM Pivot'!C"&(MATCH(D34,'SIM Pivot'!$A:$A)-1)+(MATCH($A35,'SIM Pivot'!$A:$A,0)-1)))+((INDIRECT("'SIM Pivot'!D"&(MATCH(D34,'SIM Pivot'!$A:$A)-1)+(MATCH($A35,'SIM Pivot'!$A:$A,0)-1))*Weights!$C$15))), (INDIRECT("'SIM Pivot'!C"&(MATCH(C34,'SIM Pivot'!$A:$A)-1)+(MATCH($A35,'SIM Pivot'!$A:$A,0)-1)))/((INDIRECT("'SIM Pivot'!C"&(MATCH(C34,'SIM Pivot'!$A:$A)-1)+(MATCH($A35,'SIM Pivot'!$A:$A,0)-1)))+((INDIRECT("'SIM Pivot'!D"&(MATCH(C34,'SIM Pivot'!$A:$A)-1)+(MATCH($A35,'SIM Pivot'!$A:$A,0)-1))*Weights!$C$15))), (INDIRECT("'SIM Pivot'!C"&(MATCH(B34,'SIM Pivot'!$A:$A)-1)+(MATCH($A35,'SIM Pivot'!$A:$A,0)-1)))/((INDIRECT("'SIM Pivot'!C"&(MATCH(B34,'SIM Pivot'!$A:$A)-1)+(MATCH($A35,'SIM Pivot'!$A:$A,0)-1)))+((INDIRECT("'SIM Pivot'!D"&(MATCH(B34,'SIM Pivot'!$A:$A)-1)+(MATCH($A35,'SIM Pivot'!$A:$A,0)-1))*Weights!$C$15))))) * Weights!$C$14)) * 100

 

[Cray]

I need to edit this formula, because one of the calculations is wrong. Could you have a look?

:crylaugh:

 

[Rouxenator]

Why did Satan invent VBA?

I want to know too.

 

[R4ziel]

Ask me your Excel, Macro, VBA Questions

Is Macro having a Black friday sale any time soon, and will they announce it before the time?

 

[Hamish McPanji]

:crylaugh:

Yeah, that extra comma is so obvious. You can see it straight away

 

[Zophos]

Does keeping VB.net Textbook in your car window count as a disabled sign, or do I still need to get the sticker?

 

[scudsucker]

I'm feeling generous.
Lets see how many folks I can liberate from Spreadsheet hell....

Can you help me make a spreadsheet like this one?



Excel art, by Tatsuo Horiuchi