+ Reply to Thread
Results 1 to 2 of 2

Array In Vertically Merged Cells

  1. #1
    Registered User
    Join Date
    03-26-2021
    Location
    Birmingham, Alabama
    MS-Off Ver
    Office 2016
    Posts
    7

    Array In Vertically Merged Cells

    I saw a similar thread about arrays in merged cells, but the solution only addressed arrays in horizontally merged cells. It seems asking for clarification about vertically merged cells was too different a topic.

    I am trying to create an indexing array in vertically merged cells. My attached file shows the visual I am going for. The goal is to create an array that will list out my active projects. The reason this occurs in merged cells is that for every project listed, I would like to include an array next to it which shows the 3 most recent updates logged.

    I have already figured out my array functions. What I cannot figure out is how to create an array function in vertically merged cells so that I can populate my update arrays.

    I consistently see 2 options to solve arrays in merged cells:

    1. Create the array, then merge: This only works horizontally. If you try to merge vertically, it gives the error that you cannot change any part of the array.

    2. Use a named range to create an array: This works for a single merged section. In my case, however, I want a list over multiple cells and this doesn't work. It will only populate one value.

    Is there a way to make this work? Or do I need to create the array in a hidden helper sheet and make my merged cells for Project Name a reference to the hidden helper array?

    Thanks!
    Attached Files Attached Files

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,721

    Re: Array In Vertically Merged Cells

    Merged cells can look pretty but are almost always a bad idea in Excel.

    Your file shows what you want your layout to look like but shows no formulas. Can you explain how your goal of an array in vertically merged cells applies to the file you attached?
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

+ 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. Merged Cells and Array Functions
    By KomicJ in forum Excel General
    Replies: 3
    Last Post: 06-01-2021, 02:02 PM
  2. [SOLVED] Store the values from merged cells in an array
    By YasserKhalil in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-07-2016, 11:50 AM
  3. Replies: 0
    Last Post: 11-25-2014, 07:08 AM
  4. [SOLVED] VBA Collect Values Stored in Merged Cells into Array
    By fiasco in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 02-24-2014, 11:31 PM
  5. Replies: 1
    Last Post: 08-24-2013, 12:20 PM
  6. [SOLVED] Indexing with merged cells in the Array
    By smls in forum Excel General
    Replies: 3
    Last Post: 05-21-2012, 10:15 AM
  7. Multiple lines of text in one vertically merged cell
    By excelname in forum Excel - New Users/Basics
    Replies: 5
    Last Post: 12-19-2009, 12:06 AM

Tags for this Thread

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