Enter using

[chequer - ExcelForums.com]

I am trying to learn more about Excel functions
In some of the answers to queries I have noticed
....entered using CONTROL+SHIFT+ENTE
What does this mean?
Reply to a query example

Then list the unique cities in a column, let's say Column E, an enter
the following array formula in F1 and copy down:
=AVERAGE(IF($A$1:$A$100=E1,$C$1:$C$100))
[b:34e9b407d2]....entered usin

CONTROL+SHIFT+ENTER[/b:34e9b407d2].....entered usin
CONTROL+SHIFT+ENTER[/b:34e9b407d2].[/quote:34e9b407d2

 

[Steve Mackay]

It's a special kind of formula called an "array formula". To enter it, you
type a formula like normal but instead of hitting the Enter key, you hold
down the Ctrl key and the Shift key together, then press enter. your
formula will have curly brackets signifying it is an array formula {}. You
can do things with array formulas that aren't possible with regular
formulas.

For more info, try reading this website
http://www.cpearson.com/excel/array.htm
--
Steve Mackay

I am trying to learn more about Excel functions.
In some of the answers to queries I have noticed
...entered using CONTROL+SHIFT+ENTER
What does this mean?.
Reply to a query example.

Then list the unique cities in a column, let's say Column E, and enter
the following array formula in F1 and copy down:
=AVERAGE(IF($A$1:$A$100=E1,$C$1:$C$100))
[b:34e9b407d2]....entered using

CONTROL+SHIFT+ENTER[/b:34e9b407d2].....entered using
CONTROL+SHIFT+ENTER[/b:34e9b407d2].[/quote:34e9b407d2]

 

[Gord Dibben]

See Chip Pearson's info on "Arrays"

http://www.cpearson.com/excel/array.htm

Gord Dibben Excel MVP

I am trying to learn more about Excel functions.
In some of the answers to queries I have noticed
...entered using CONTROL+SHIFT+ENTER
What does this mean?.
Reply to a query example.

Then list the unique cities in a column, let's say Column E, and enter
the following array formula in F1 and copy down:
=AVERAGE(IF($A$1:$A$100=E1,$C$1:$C$100))
[b:34e9b407d2]....entered using

CONTROL+SHIFT+ENTER[/b:34e9b407d2].....entered using
CONTROL+SHIFT+ENTER[/b:34e9b407d2].[/quote:34e9b407d2]