Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Jenna Ryan   on Nov 08 In MS Office Category.

  
Question Answered By: Andrew Brown   on Nov 08

The function has to be array-entered because it is returning a
2-dimensional array of values. That is, you have to highlight a
range, type  in the formula, then hit Ctrl-Shift-ENTER to array-enter
the formula. That's because an EXCEL function can only return a value
or values to a cell  or range that it has been given access to. When
you just enter the formula and hit ENTER, you've only given the
function the ability to return a single value into a single cell --
which is what you got: "Date".

The easiest way to expand that is to:

1. Highlight that cell again
2. Hold down the shift key and use the arrow keys to expand the
highlighted area over additional rows and columns
3. Press F2 to edit the formula
4. Hit Ctrl-Shift-ENTER to array-enter the function over the highlighted range
5. If you are missing parts of the table  and need more rows or
columns, hit Ctrl-Z to undo and repeat steps (2) through (4).

I sometimes use that technique as a trial and error process to see how
many rows and columns I actually need.

Share: 

 

This Question has 15 more answer(s). View Complete Question Thread

 
Didn't find what you were looking for? Find more on Web query question Or get search suggestion and latest updates.


Tagged: