Re: Using Min & Max to sort log times.

Tech-Archive recommends: Fix windows errors by optimizing your registry



To "array-enter" means to press CTRL+SHIFT+ENTER [CSE] in confirming the
formula (instead of just pressing ENTER). If you did this confirmation
correctly, you should see Excel wrap curly braces: { } around the formula in
the formula bar. If you don't see the curlies, that means it's not correctly
array-entered. Click inside the formula bar and try the CSE again.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---


.



Relevant Pages

  • Re: SUMPRODUCT + ISNUMBER(SEARCH) + Empty Cells
    ... instead of just pressing ENTER. ... When it's done correctly, Excel will ... wrap curly braces around the formula, which you can see inside the ... Click inside the formula bar again, ...
    (microsoft.public.excel.misc)
  • Re: Compare arrays
    ... put in K1's formula bar, then array-enter the formula by pressing ... CTRL+SHIFT+ENTER (instead of just pressing ENTER): ... "mavxob" wrote: ... that match the lookup column. ...
    (microsoft.public.excel.worksheet.functions)
  • Re: CountIf question
    ... After you array-enter the formula by pressing CTRL+SHIFT+ENTER in H2, ... in the formula bar where you should see Excel wrap curly braces around the ...
    (microsoft.public.excel.worksheet.functions)
  • Re: undating new value while keeping the old
    ... Put in the formula bar for A1, ... then array-enter the formula by pressing CTRL+SHIFT+ENTER ... The above was taken from Bob Phillip's fine page at: ...
    (microsoft.public.excel.misc)
  • Re: Excel Vlookup Problems Help!
    ... MATCH statement? ... Put in the formula bar for E2, ... by pressing CTRL+SHIFT+ENTER: ... mr_teacher's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=34352 ...
    (microsoft.public.excel.worksheet.functions)