Thread
:
Array function does not seem to work
View Single Post
#
19
Posted to microsoft.public.excel.misc
Sandy Mann
external usenet poster
Posts: 2,345
Array function does not seem to work
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
Replace @mailinator.com with @tiscali.co.uk
"Bob Phillips" wrote in message
...
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)
"Sandy Mann" wrote in message
...
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
Replace @mailinator.com with @tiscali.co.uk
"Bob Phillips" wrote in message
...
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
"Sandy Mann" wrote in message
...
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
"Sandy Mann" wrote in message
...
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
"Bob Phillips" wrote in message
...
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.
"Sandy Mann" wrote in message
...
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.
"Bob Phillips" wrote in message
...
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.
"dartanion" wrote in
message
...
Thanks Sandy, I changed all the , to ; and the array works.
WHY??
"Sandy Mann" wrote:
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
;
"dartanion" wrote in
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?
"Bernard Liengme" wrote:
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
...
Reply With Quote
Sandy Mann
View Public Profile
Find all posts by Sandy Mann