+ Reply to Thread
Results 1 to 6 of 6

Multiple Array Formula & CTRL+SHIFT+ENTER

  1. #1
    Registered User
    Join Date
    12-04-2012
    Location
    UK
    MS-Off Ver
    Excel 2010
    Posts
    14

    Multiple Array Formula & CTRL+SHIFT+ENTER

    Hi,

    I'm having a slight issue with a multiple array formula I am using to copy over data from one worksheet to another.

    The formula works ok but as is it a Multiply Array I have to press CTRL+SHIFT+ENTER. However my original spreadsheet has over 15,000 lines of data and as each formula differs slightly I cannot find a way to 'bulk edit' all the cells to generate the true result.

    Can anyone make any suggestions on how to improve this file? maybe us another type of calculation? e.g VLOOKUP?

    The formula is -
    Please Login or Register  to view this content.
    https://skydrive.live.com/redir?resi...t=file%2c.xlsx

  2. #2
    Forum Expert
    Join Date
    12-03-2009
    Location
    Florence, Italy
    MS-Off Ver
    Excel 2019
    Posts
    1,796

    Re: Multiple Array Formula & CTRL+SHIFT+ENTER

    Hi,

    in C2 and down maybe could help you


    Please Login or Register  to view this content.
    Regards
    Last edited by canapone; 02-04-2014 at 06:11 AM.
    -----------------------------------------------------

    At Excelforum, you can say "Thank you!" by clicking the star icon ("Add Reputation") below the post.

    Please, mark your thread [SOLVED] if you received your answer.

  3. #3
    Forum Expert
    Join Date
    12-03-2009
    Location
    Florence, Italy
    MS-Off Ver
    Excel 2019
    Posts
    1,796

    Re: Multiple Array Formula & CTRL+SHIFT+ENTER

    Hi again,

    another possibility: just copy the formula in C2 and down and to the right

    Please Login or Register  to view this content.

    Regards
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    12-04-2012
    Location
    UK
    MS-Off Ver
    Excel 2010
    Posts
    14

    Re: Multiple Array Formula & CTRL+SHIFT+ENTER

    Quote Originally Posted by CANAPONE View Post
    Hi again,

    another possibility: just copy the formula in C2 and down and to the right

    Please Login or Register  to view this content.

    Regards
    Amazing! Thank you very much :D

  5. #5
    Forum Expert
    Join Date
    12-03-2009
    Location
    Florence, Italy
    MS-Off Ver
    Excel 2019
    Posts
    1,796

    Re: Multiple Array Formula & CTRL+SHIFT+ENTER

    Hi,

    thanks for feedback.

    Regards

  6. #6
    Registered User
    Join Date
    07-30-2014
    Location
    LA, CA
    MS-Off Ver
    2003
    Posts
    1

    Re: Multiple Array Formula & CTRL+SHIFT+ENTER

    Hello All,

    I am in a similar situation. I need to activate an excel formula like "=SUM(IF(MOD(COLUMN($F$2:$ET$2),2)=0,$F$2:$ET$2,0))" across 3000 rows. It's tedious to press F2 and then press ctrl+shift+Enter for every cell. I am novice to VBA. Can some one help me with a short cut to activate all the cells at one go? There was link mentioned in the below thread and I am not able to locate the exact solution in the excel forum. Appreciate if anyone can help on this.

+ 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. [SOLVED] (urgent help pls) how to apply array formula with ctrl+shift+enter
    By otabokauyelikicin in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-07-2013, 09:56 AM
  2. 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
  3. Array Formula: Ctrl+Shift+Enter does not work
    By georgroth in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-30-2013, 12:15 PM
  4. [SOLVED] CTRL+SHIFT+ENTER array formula not working
    By frusterated in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-05-2012, 12:02 AM
  5. Array Formula: CTRL+SHIFT+ENTER?
    By WebKill in forum Excel General
    Replies: 2
    Last Post: 05-27-2011, 01:56 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