Results 1 to 10 of 10

Adding a new column with row text for each vstack array

Threaded View

benoj2005 Adding a new column with row... 11-15-2024, 05:29 AM
windknife Re: Adding a new column with... 11-15-2024, 05:37 AM
zbor Re: Adding a new column with... 11-15-2024, 05:44 AM
benoj2005 Re: Adding a new column with... 11-15-2024, 06:06 AM
windknife Re: Adding a new column with... 11-15-2024, 06:07 AM
benoj2005 Re: Adding a new column with... 11-15-2024, 06:13 AM
windknife Re: Adding a new column with... 11-15-2024, 07:40 AM
RhiSJ Re: Adding a new column with... 11-15-2024, 07:54 AM
AliGW Re: Adding a new column with... 11-15-2024, 06:31 AM
benoj2005 Re: Adding a new column with... 11-15-2024, 08:03 AM
  1. #1
    Forum Contributor
    Join Date
    02-14-2012
    Location
    Warrington
    MS-Off Ver
    Excel 365
    Posts
    497

    Adding a new column with row text for each vstack array

    Hopefully a nice an easy one but I'm not sure what the right approach is to add a new column to vstacks that dosen't exist in the source data and then to add row text to this new column to show the source of each vstack array.

    Simple example in the attached where I've done column I manually

    Thankyou

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] VSTACK all ranges in Spill array
    By Andrew-Mark in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-10-2023, 07:26 AM
  2. [SOLVED] feed single array via VSTACK and REDUCE issue
    By guillaume0314 in forum Excel Formulas & Functions
    Replies: 17
    Last Post: 09-16-2023, 08:25 AM
  3. VSTACK results of indirect references from an array
    By tdarenkov in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-16-2023, 04:11 AM
  4. [SOLVED] Adding column to an array
    By ChipsSlave in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-21-2017, 05:22 AM
  5. Replies: 5
    Last Post: 11-24-2015, 08:15 AM
  6. Change date into text if <today and adding text if cell isblank... into an Array.
    By JasonNeedsHelp in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-29-2013, 12:06 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