Array function does not seem to work

[dartanion]

Over the last few days, I have sought and received help from the community.
The help has been with formulas requiring array answers.
Each time I try the cntr-shift-enter, an error appears in the middle of the
formula. e.g Mike gave me this fomula
=INDEX(C1:C1000,LARGE(IF(C1000<>"",ROW(C1:C1000)),2)) I used the
ctrl-shift-enter and an error came up and C1000,LARGE was highlighted. I then
went on to the array learning module, and entered an array formula for part
of that study, and again an error message appeared with a similar part of
their function highlighted as an error. Anyone suggest solution?

 

[Bernard Liengme]

Not sure what you are doing but I wonder if the formula should be
=INDEX(C1:C1000,LARGE(IF(C1:C1000<>"",ROW(C1:C1000)),2))
the change being just after IF(
best wishes

 

[dartanion]

Thanks Bernard, but no the same error appeared, which suggests to me its not
the formula, but something in excel, what do you think, and any ideas what I
can test?

 

[Sandy Mann]

ctrl-shift-enter and an error came up and C1000,LARGE was highlighted.

Do you use semi-colon separator or comma? If so change the , to ;

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

 

[Bob Phillips]

See my post in your other thread, I should have updated it to continental
separators

=INDEX(C1:C1000;LARGE(IF(C1:C1000<>"";ROW(C1:C1000));2))


--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[dartanion]

Thanks Sandy, I changed all the , to ; and the array works. WHY??

 

[Bob Phillips]

Because you have a continental version of Excel which uses comma as the
decimal separator, so semi-colon is used as the list separator. Our English
version is dot and comma.

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Sandy Mann]

I thought that you had adequately explained the reason in the other thread
Bob so I did not respond. However, because it was in *another thread* I
suppose that for completeness in the archives it did require an answer.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

 

[Bob Phillips]

Hi sandy,

I thought you were watching Inverness Cali <bg>.

I wondered if he actually read that thread anymore after he got his answer
here.

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Sandy Mann]

It was only lately that I found out that *Celtic* is actually an acronym.
Yes it's true, it stands for:

Can Even Lose To Inverness Cali <G>

--
Regards,


Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

 

[David Biddulph]

Will the Sun rerun what must be widely regarded as the best headline of all
time?
--
David Biddulph

It was only lately that I found out that *Celtic* is actually an acronym.
Yes it's true, it stands for:

Can Even Lose To Inverness Cali <G>

....

 

[Sandy Mann]

Hi David,

I don't read the Sun, (I don't think that the Sun readers do either do they?
<g>). What was the headline?

--
Regards,

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

 

[David Biddulph]

I don't read the Sun, either, but this dates back to the days when lowly
Caley knocked Celtic out of the Scottish FA Cup in 2000, and the famous
headline was:
"Super Caley Go Ballistic Celtic Are Atrocious".

 

[Sandy Mann]

LOL

--

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

 

[Bob Phillips]

Damn. You beat me to it, I was lining that one up <G>

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Bob Phillips]

They can't!

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Sandy Mann]

Just to set the record straight I support St Johnston. That is St Johnston
FC not, as many people think, St Johnston Nil <g>

--
Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

Damn. You beat me to it, I was lining that one up <G>

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my
addy)

I don't read the Sun, either, but this dates back to the days when lowly
Caley knocked Celtic out of the Scottish FA Cup in 2000, and the famous
headline was:
"Super Caley Go Ballistic Celtic Are Atrocious".
--
David Biddulph

Hi David,

I don't read the Sun, (I don't think that the Sun readers do either do
they? <g>). What was the headline?

"David Biddulph" <groups [at] biddulph.org.uk> wrote in message
Will the Sun rerun what must be widely regarded as the best headline of
all time?
--
David Biddulph

It was only lately that I found out that *Celtic* is actually an
acronym. Yes it's true, it stands for:

Can Even Lose To Inverness Cali <G>

Hi sandy,

I thought you were watching Inverness Cali <bg>.

I wondered if he actually read that thread anymore after he got his
answer here.

I thought that you had adequately explained the reason in the other
thread
Bob so I did not respond. However, because it was in *another
thread* I
suppose that for completeness in the archives it did require an
answer.

Because you have a continental version of Excel which uses comma as
the
decimal separator, so semi-colon is used as the list separator. Our
English version is dot and comma.

Thanks Sandy, I changed all the , to ; and the array works. WHY??

:

ctrl-shift-enter and an error came up and C1000,LARGE was
highlighted.

Do you use semi-colon separator or comma? If so change the , to ;

message
Thanks Bernard, but no the same error appeared, which suggests
to me
its
not
the formula, but something in excel, what do you think, and any
ideas
what
I
can test?

:

Not sure what you are doing but I wonder if the formula should
be
=INDEX(C1:C1000,LARGE(IF(C1:C1000<>"",ROW(C1:C1000)),2))
the change being just after IF(
best wishes
...

 

[Bob Phillips]

Well you have to admit, the two do go hand in hand.

So tell me, where/what is St Johnston?

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)

Just to set the record straight I support St Johnston. That is St
Johnston FC not, as many people think, St Johnston Nil <g>

--
Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

Damn. You beat me to it, I was lining that one up <G>

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my
addy)

I don't read the Sun, either, but this dates back to the days when lowly
Caley knocked Celtic out of the Scottish FA Cup in 2000, and the famous
headline was:
"Super Caley Go Ballistic Celtic Are Atrocious".
--
David Biddulph

Hi David,

I don't read the Sun, (I don't think that the Sun readers do either do
they? <g>). What was the headline?

"David Biddulph" <groups [at] biddulph.org.uk> wrote in message
Will the Sun rerun what must be widely regarded as the best headline
of all time?
--
David Biddulph

It was only lately that I found out that *Celtic* is actually an
acronym. Yes it's true, it stands for:

Can Even Lose To Inverness Cali <G>

Hi sandy,

I thought you were watching Inverness Cali <bg>.

I wondered if he actually read that thread anymore after he got his
answer here.

I thought that you had adequately explained the reason in the other
thread
Bob so I did not respond. However, because it was in *another
thread* I
suppose that for completeness in the archives it did require an
answer.

Because you have a continental version of Excel which uses comma
as the
decimal separator, so semi-colon is used as the list separator.
Our
English version is dot and comma.

Thanks Sandy, I changed all the , to ; and the array works. WHY??

:

ctrl-shift-enter and an error came up and C1000,LARGE was
highlighted.

Do you use semi-colon separator or comma? If so change the , to
;

message
Thanks Bernard, but no the same error appeared, which suggests
to me
its
not
the formula, but something in excel, what do you think, and
any ideas
what
I
can test?

:

Not sure what you are doing but I wonder if the formula
should be
=INDEX(C1:C1000,LARGE(IF(C1:C1000<>"",ROW(C1:C1000)),2))
the change being just after IF(
best wishes
...

 

[Sandy Mann]

St Johnston is Perth's football team. Perth is *Saint John's Town*

http://en.wikipedia.org/wiki/Perth,_Scotland

also says why I say in my signature the Perth is the ancient capital of
Scotland and the crowning place of kings.

--
Regards,

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

Well you have to admit, the two do go hand in hand.

So tell me, where/what is St Johnston?

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my
addy)

Just to set the record straight I support St Johnston. That is St
Johnston FC not, as many people think, St Johnston Nil <g>

--
Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

Damn. You beat me to it, I was lining that one up <G>

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my
addy)



"David Biddulph" <groups [at] biddulph.org.uk> wrote in message
I don't read the Sun, either, but this dates back to the days when lowly
Caley knocked Celtic out of the Scottish FA Cup in 2000, and the famous
headline was:
"Super Caley Go Ballistic Celtic Are Atrocious".
--
David Biddulph

Hi David,

I don't read the Sun, (I don't think that the Sun readers do either do
they? <g>). What was the headline?

"David Biddulph" <groups [at] biddulph.org.uk> wrote in message
Will the Sun rerun what must be widely regarded as the best headline
of all time?
--
David Biddulph

It was only lately that I found out that *Celtic* is actually an
acronym. Yes it's true, it stands for:

Can Even Lose To Inverness Cali <G>

Hi sandy,

I thought you were watching Inverness Cali <bg>.

I wondered if he actually read that thread anymore after he got his
answer here.

I thought that you had adequately explained the reason in the other
thread
Bob so I did not respond. However, because it was in *another
thread* I
suppose that for completeness in the archives it did require an
answer.

Because you have a continental version of Excel which uses comma
as the
decimal separator, so semi-colon is used as the list separator.
Our
English version is dot and comma.

message
Thanks Sandy, I changed all the , to ; and the array works.
WHY??

:

ctrl-shift-enter and an error came up and C1000,LARGE was
highlighted.

Do you use semi-colon separator or comma? If so change the , to
;

message
Thanks Bernard, but no the same error appeared, which
suggests to me
its
not
the formula, but something in excel, what do you think, and
any ideas
what
I
can test?

:

Not sure what you are doing but I wonder if the formula
should be
=INDEX(C1:C1000,LARGE(IF(C1:C1000<>"",ROW(C1:C1000)),2))
the change being just after IF(
best wishes
...

 

[Bob Phillips]

I got your place of residence, but I never knew that St Johnston was located
in Perth. I always assumed it was one of those Glasgow peripheral teams.

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)

St Johnston is Perth's football team. Perth is *Saint John's Town*

http://en.wikipedia.org/wiki/Perth,_Scotland

also says why I say in my signature the Perth is the ancient capital of
Scotland and the crowning place of kings.

--
Regards,

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

Well you have to admit, the two do go hand in hand.

So tell me, where/what is St Johnston?

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my
addy)

Just to set the record straight I support St Johnston. That is St
Johnston FC not, as many people think, St Johnston Nil <g>

--
Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk


Damn. You beat me to it, I was lining that one up <G>

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my
addy)



"David Biddulph" <groups [at] biddulph.org.uk> wrote in message
I don't read the Sun, either, but this dates back to the days when
lowly Caley knocked Celtic out of the Scottish FA Cup in 2000, and the
famous headline was:
"Super Caley Go Ballistic Celtic Are Atrocious".
--
David Biddulph

Hi David,

I don't read the Sun, (I don't think that the Sun readers do either
do they? <g>). What was the headline?

"David Biddulph" <groups [at] biddulph.org.uk> wrote in message
Will the Sun rerun what must be widely regarded as the best headline
of all time?
--
David Biddulph

It was only lately that I found out that *Celtic* is actually an
acronym. Yes it's true, it stands for:

Can Even Lose To Inverness Cali <G>

Hi sandy,

I thought you were watching Inverness Cali <bg>.

I wondered if he actually read that thread anymore after he got
his answer here.

I thought that you had adequately explained the reason in the
other thread
Bob so I did not respond. However, because it was in *another
thread* I
suppose that for completeness in the archives it did require an
answer.

Because you have a continental version of Excel which uses comma
as the
decimal separator, so semi-colon is used as the list separator.
Our
English version is dot and comma.

message
Thanks Sandy, I changed all the , to ; and the array works.
WHY??

:

ctrl-shift-enter and an error came up and C1000,LARGE was
highlighted.

Do you use semi-colon separator or comma? If so change the ,
to ;

message
Thanks Bernard, but no the same error appeared, which
suggests to me
its
not
the formula, but something in excel, what do you think, and
any ideas
what
I
can test?

:

Not sure what you are doing but I wonder if the formula
should be
=INDEX(C1:C1000,LARGE(IF(C1:C1000<>"",ROW(C1:C1000)),2))
the change being just after IF(
best wishes
...