Thread
:
Array function does not seem to work
View Single Post
#
4
Posted to microsoft.public.excel.misc
Sandy Mann
external usenet poster
Posts: 2,345
Array function does not seem to work
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
Replace @mailinator.com with @tiscali.co.uk
"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
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email
"dartanion" wrote in message
...
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?
Reply With Quote
Sandy Mann
View Public Profile
Find all posts by Sandy Mann