+ Reply to Thread
Results 1 to 7 of 7

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

Hybrid View

  1. 03-26-2015, 01:24 PM #1
    erkamu
    erkamu is offline
    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
    Reply With QuoteRegister To Reply
  2. 03-26-2015, 01:35 PM #2
    XOR LX
    XOR LX is offline
    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/
    Reply With QuoteRegister To Reply
  3. 03-26-2015, 03:15 PM #3
    erkamu
    erkamu is offline
    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
    Reply With QuoteRegister To Reply
  4. 03-26-2015, 03:28 PM #4
    XOR LX
    XOR LX is offline
    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
    Reply With QuoteRegister To Reply
  5. 03-26-2015, 04:00 PM #5
    erkamu
    erkamu is offline
    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.
    Reply With QuoteRegister To Reply
  6. 03-27-2015, 03:30 AM #6
    XOR LX
    XOR LX is offline
    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
    Reply With QuoteRegister To Reply
  7. 03-27-2015, 08:23 AM #7
    JosephP
    JosephP is offline
    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 
    =IF(COUNTIF(H839:H914,"D")>0,"D.",IF(COUNTIF(H839:H914,11)>0,"11.",IF(COUNTIF(H839:H914,10)>0,"10.",IF(COUNTIF(H839:H914,9)>0,"9.",IF(COUNTIF(H839:H914,8)>0,"8.",IF(COUNTIF(H839:H914,7)>0,"7.",IF(COUNTIF(H839:H914,6)>0,"6.",IF(COUNTIF(H839:H914,5)>0,"5.",IF(COUNTIF(H839:H914,4)>0,"4.",IF(COUNTIF(H839:H914,3)>0,"3.",IF(COUNTIF(H839:H914,2)>0,"2.",IF(COUNTIF(H839:H914,1)>0,"1.",""))))))))))))

    which doesn't need array entry? or maybe this
    Formula: copy to clipboard 
    =IFERROR(LOOKUP(2,1/COUNTIF(H839:H914,{1,2,3,4,5,6,7,8,9,10,11,"D"}),{"1.","2.","3.","4.","5.","6.","7.","8.","9.","10.","11.","D."}),"")
    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 With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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. 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. What does hitting Ctrl + Shift + Enter to enter a formula do??? Help a n00b out.
    By qwopzxnm in forum Excel Formulas & Functions
    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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1