Can't create Array

[heski]

Hi,

I'm trying to create an array formula by pressing CTLR-SHIFT-ENTER together, but excel does not seem to be responding.

Can anyone suggest why not, and how to resolve (and whether this is connected to my "No Control" problem.

Many Thanks,

Heski

[Bryan Hessey]

Hi,

I'm trying to create an array formula by pressing CTLR-SHIFT-ENTER together, but excel does not seem to be responding.

Can anyone suggest why not, and how to resolve (and whether this is connected to my "No Control" problem.

Many Thanks,

Heski

CSE is to enter a formula that contains an array which Excel might not expect, what formula are you trying to enter?

What is your 'No Control' problem?

---

[heski]

Hi Bryan,

Thanks for your response

The array formulas were some examples I had received. Eg:

=SUM(IF(ISNUMBER(FIND(C2,B2:B5)),VALUE(LEFT(B2:B5,FIND(C2,B2:B5)-1)),0))

=INDEX(A2:A7,MATCH(1,(B2:B7=D2)*(C2:C7<D3)))

I also tried simple formulas, such as Sum

The Control Problem was a post I made earlier in the day:

"I'm trying to use control drop down lists and scroll bars, but the control tab is not showing so I cannot link the list or bar to a cell.

Can anyone suggest how to resolve this problem?

Thanks in advance"

[Bryan Hessey]

Hi Bryan,

Thanks for your response

The array formulas were some examples I had received. Eg:

=SUM(IF(ISNUMBER(FIND(C2,B2:B5)),VALUE(LEFT(B2:B5,FIND(C2,B2:B5)-1)),0))

If you Tools, Formula Auditing, Evaluate Formula, you will progress the formula to see that you are trying to IsNumber the results of a Find, but I think this is not what you might be thinking you should do.

=INDEX(A2:A7,MATCH(1,(B2:B7=D2)*(C2:C7<D3)))

I do not understand the format of this formula, the =INDEX(A2:A7, needs to be followd by two numbers, but MATCH(1,(B2:B7=D2)*(C2:C7<D3) doesn't look like the formula that will provide these, again, try the Formula Ecaluate to see what Excel makes of the formula you have submitted.

I also tried simple formulas, such as Sum

Not sure where you got the formulae from, but a return to that point for a clarification could be wise.

hth
---