+ Reply to Thread
Results 1 to 8 of 8

Array to Display Row of Data

Hybrid View

profess Array to Display Row of Data 05-17-2019, 05:59 PM
Glenn Kennedy Re: Array to Display Row of... 05-18-2019, 11:10 AM
profess Re: Array to Display Row of... 05-20-2019, 01:57 PM
FlameRetired Re: Array to Display Row of... 05-21-2019, 12:35 AM
profess Re: Array to Display Row of... 05-21-2019, 11:11 AM
FlameRetired Re: Array to Display Row of... 05-21-2019, 12:17 PM
profess Re: Array to Display Row of... 05-21-2019, 04:52 PM
JeteMc Re: Array to Display Row of... 05-26-2019, 04:03 PM
  1. #1
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 365 version 2504
    Posts
    19,083

    Re: Array to Display Row of Data

    This proposal employs three helper columns, which may be moved and/or hidden for aesthetic purposes.
    On the Data Set sheet column H, Group members, is populated using: =B2&C2&D2&E2&F2&G2
    Column I, Group #, is populated using: =MATCH(H2,H$2:H2,0)
    On the Output sheet column A is populated using: =IFERROR(AGGREGATE(15,6,'Data Set'!I$2:I$25,ROWS(A$1:A1)),"")
    Column B is populated using: =IF(A5="","",INDEX('Data Set'!A$2:A$25,AGGREGATE(15,6,(ROW(A$2:A$25)-ROW(A$1))/('Data Set'!I$2:I$25=A5),COUNTIFS(A$5:A5,A5))))
    Columns C:AB are populated using: =IF(A5="","",INDEX('Data Set'!J$2:J$25,MATCH($B5,'Data Set'!$A$2:$A$25,0)))
    Let us know if you have any questions.
    Attached Files Attached Files
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ 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] Find text in array and display related data
    By KimMorgan in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 06-17-2016, 04:53 PM
  2. [SOLVED] Display pivot Table in an Listbox from Array data
    By evertjvr in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-25-2015, 03:01 AM
  3. display collected array data in a MsgBox
    By UMBiii in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-21-2014, 01:24 PM
  4. Array formula to automate display of Fleet List data from a Table
    By azatherazza in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-20-2014, 04:06 AM
  5. Array search - display project data and column number for further indexing
    By zenqueth in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-26-2012, 07:26 AM
  6. Help with formula to display an array of data
    By MISC_IT in forum Excel General
    Replies: 3
    Last Post: 05-30-2012, 03:20 PM
  7. Display an Array of Data Based on Other Data
    By nycstinger in forum Excel General
    Replies: 8
    Last Post: 09-18-2009, 06:55 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