Re: Top 10 Text Values

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Domenic <domenic22@xxxxxxxxxxxx>
Date: Thu, 29 Dec 2005 14:32:32 -0500

CONTROL+SHIFT+ENTER is used when dealing with array formulas. For a
detailed explanation, have a look in Excel's help menu under 'Array
Formula'.

In article <DE9FF35C-F403-44E6-B487-DAB0D2D33F72@xxxxxxxxxxxxx>,
KarenH <KarenH@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

> What does the CONTROL+SHIFT+ENTER do that ENTER doesnt? I notice it puts
> little curly brackets around the formula -- and that if I just enter, the
> values don't come out right -- but I'm wondering what exactly that
> combination does. Thanks again!
.

References:
- Re: Top 10 Text Values
  - From: Domenic

Prev by Date: Re: Text manipulation
Next by Date: Re: how to use sumif function to check date in 1 *** is < 2 ***
Previous by thread: Re: Top 10 Text Values
Next by thread: Re: Top 10 Text Values
Index(es):
- Date
- Thread