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?