+ Reply to Thread
Results 1 to 7 of 7

why CTRL SHIFT ENTER in my excel does not give braces { }?

  1. #1
    Forum Contributor
    Join Date
    01-20-2011
    Location
    liverpool
    MS-Off Ver
    Excel 2016
    Posts
    198

    why CTRL SHIFT ENTER in my excel does not give braces { }?

    Hello,
    In my file I have that formula

    =IF((COUNT(IF(H839:H914="D",ROW(839:914))))>0,"D.",IF((COUNT(IF(H839:H914=11,ROW(839:914))))>0,"11.",IF((COUNT(IF(H839:H914=10,ROW(839:914))))>0,"10.",IF((COUNT(IF(H839:H914=9,ROW(839:914))))>0,"9.",IF((COUNT(IF(H839:H914=8,ROW(839:914))))>0,"8.",IF((COUNT(IF(H839:H914=7,ROW(839:914))))>0,"7.",IF((COUNT(IF(H839:H914=6,ROW(839:914))))>0,"6.",IF((COUNT(IF(H839:H914=5,ROW(839:914))))>0,"5.",IF((COUNT(IF(H839:H914=4,ROW(839:914))))>0,"4.",IF((COUNT(IF(H839:H914=3,ROW(839:914))))>0,"3.",IF((COUNT(IF(H839:H914=2,ROW(839:914))))>0,"2.",IF((COUNT(IF(H839:H914=1,ROW(839:914))))>0,"1.",""))))))))))))


    that requires CTRL SHIFT ENTER in order to work properly.
    The point is that when I press that combination I do not have the curly braces { }.
    If I paste that formula to ananother empty xls and press CTRL SHIFT ENTER - curly braces { } appear.

    What could be the reason for that?

    Thanks!
    erkamu

  2. #2
    Forum Expert XOR LX's Avatar
    Join Date
    04-18-2013
    Location
    Turin, Italy
    MS-Off Ver
    Office 365
    Posts
    7,742

    Re: why CTRL SHIFT ENTER in my excel does not give braces { }?

    Hi.

    What does appear in the cell? A formula? Or the result of a formula? An error?

    Regards
    Click * below if this answer helped

    Advanced Excel Techniques: http://excelxor.com/

  3. #3
    Forum Contributor
    Join Date
    01-20-2011
    Location
    liverpool
    MS-Off Ver
    Excel 2016
    Posts
    198

    Re: why CTRL SHIFT ENTER in my excel does not give braces { }?

    When i mark onto the cell formula is there but there is no curly braces

  4. #4
    Forum Expert XOR LX's Avatar
    Join Date
    04-18-2013
    Location
    Turin, Italy
    MS-Off Ver
    Office 365
    Posts
    7,742

    Re: why CTRL SHIFT ENTER in my excel does not give braces { }?

    No. I mean - what's actually in the cell, not the formula bar?

    Regards

  5. #5
    Forum Contributor
    Join Date
    01-20-2011
    Location
    liverpool
    MS-Off Ver
    Excel 2016
    Posts
    198

    Re: why CTRL SHIFT ENTER in my excel does not give braces { }?

    In the cell i have the result of the formula. (eventhough the curly braces are not there). The point is that after some time when i open the file the efect of ctrl shift enter has gone.then i have to do the cntrl shift enter again. Curly braces are not there but the formula result iscorrect in the cell.

  6. #6
    Forum Expert XOR LX's Avatar
    Join Date
    04-18-2013
    Location
    Turin, Italy
    MS-Off Ver
    Office 365
    Posts
    7,742

    Re: why CTRL SHIFT ENTER in my excel does not give braces { }?

    Perhaps you can post a workbook with an example of this phenomenon?

    Regards

  7. #7
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: why CTRL SHIFT ENTER in my excel does not give braces { }?

    why not
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    which doesn't need array entry? or maybe this
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Last edited by JosephP; 03-27-2015 at 08:31 AM.
    Josie

    if at first you don't succeed try doing it the way your wife told you to

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. With VBA Enter Ctrl Shift Enter For Array Formula
    By realniceguy5000 in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 08-17-2013, 09:02 AM
  2. What the replacement of pressing ctrl+shift+enter in vba excel code
    By siba in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 12-29-2012, 11:39 AM
  3. What's the use of CTRL-SHIFT ENTER?
    By geng in forum Excel General
    Replies: 2
    Last Post: 05-31-2010, 03:31 AM
  4. [SOLVED] What does Ctrl+Shift+Enter do? How does it differ from Enter?
    By George Furnell in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-16-2006, 02:45 AM
  5. Replies: 2
    Last Post: 10-20-2005, 05:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1