View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
dartanion dartanion is offline
external usenet poster
 
Posts: 31
Default Array function does not seem to work

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?