Thread
:
Array function does not seem to work
View Single Post
#
14
Posted to microsoft.public.excel.misc
Sandy Mann
external usenet poster
Posts: 2,345
Array function does not seem to work
LOL
--
Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings
Replace @mailinator.com with @tiscali.co.uk
"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