Results 1 to 6 of 6

concat dynamic arrays via IDs

Threaded View

  1. #1
    Forum Contributor
    Join Date
    09-15-2022
    Location
    Marseille, France
    MS-Off Ver
    O365 (PC) V 2303
    Posts
    265

    concat dynamic arrays via IDs

    Dear Friends:

    The scenario is as follow. In G3# I have a dynamic array, 2 cols, with an ID, and a value1. in J3#, another dynamic array, 2 cols, with an ID, and a value2.

    I need to concat each value 1 with all corresponding values2 depending on the ID, and return an array in M3# listing all the results.

    concat dynamic arrays via ids.jpg

    Ideas anyone? Thank you so much.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Filter and concat text as an dynamic array
    By v6093486218 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-13-2022, 11:29 AM
  2. How to generate arrays name using concat or similar functions
    By nima50 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-10-2021, 07:18 AM
  3. [SOLVED] extract last 3 numbers from each concat. value in col. B and add to col. A concat cells
    By therealdees in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 04-17-2021, 11:02 AM
  4. Dynamic Arrays, Dynamic Drop down list, Filters and multiple rows
    By Big_Kev007 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-09-2020, 06:35 AM
  5. Dynamic concat of table headers
    By Otto62 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-15-2017, 07:28 AM
  6. VBA help with Match & Concat using Arrays....
    By sgtgooba in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-30-2013, 12:19 PM
  7. Dynamic Arrays
    By chaz in forum Excel General
    Replies: 1
    Last Post: 05-22-2006, 07:50 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