+ Reply to Thread
Results 1 to 6 of 6

Formula to return data from multiple columns

  1. 06-05-2017, 01:36 PM #1
    excelhelpguy123
    excelhelpguy123 is offline
    Registered User
    Join Date
    06-03-2016
    Location
    United States
    MS-Off Ver
    2013
    Posts
    33

    Formula to return data from multiple columns

    Hello,

    The attached example contains three tabs. There is a team name, for example the Kansas City Comets, and then players listed underneath. I would like the height and weight of the first player for each team to be listed in a table. Sometimes the team names get misaligned so there is not a set format for each one. I am running a macro through each one so I need a set formula that can return the height and weight if it is in a different place.

    Original post was not representative of my data set. My apologies.

    Thank you in advance.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 06-05-2017, 03:15 PM #2
    dflak
    dflak is offline
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    365
    Posts
    7,920

    Re: Formula to return data from multiple columns

    Do I only have to worry about columns B:D and can I be assured that height and weight have two entries while other metrics have three. I need to figure out if I have to use VBA or maybe "get away with" an array formula.
    One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.

    A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.
    Reply With QuoteRegister To Reply
  3. 06-05-2017, 03:24 PM #3
    excelhelpguy123
    excelhelpguy123 is offline
    Registered User
    Join Date
    06-03-2016
    Location
    United States
    MS-Off Ver
    2013
    Posts
    33

    Re: Formula to return data from multiple columns

    Height and weight will always be the only two sets of data I want returned from the lower data tables. There will not be another column with those same headers. The data under running for each team varies but there will always be those three columns.
    Reply With QuoteRegister To Reply
  4. 06-06-2017, 11:00 AM #4
    JeteMc
    JeteMc is offline
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,570

    Re: Formula to return data from multiple columns

    This proposed solution employs a helper column (E) which may be moved and/or hidden for aesthetic purposes.
    The formula that populates the helper column is:
    Formula: copy to clipboard 
    Please Login or Register  to view this content.

    The array entered formula* that populates the first names is:
    Formula: copy to clipboard 
    Please Login or Register  to view this content.

    The formula that populates the heights and weights is:
    Formula: copy to clipboard 
    Please Login or Register  to view this content.

    *Array entered formulas are activated by simultaneously pressing the Ctrl, Shift and Enter keys while the cell is in edit mode.
    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 With QuoteRegister To Reply
  5. 06-06-2017, 02:40 PM #5
    excelhelpguy123
    excelhelpguy123 is offline
    Registered User
    Join Date
    06-03-2016
    Location
    United States
    MS-Off Ver
    2013
    Posts
    33

    Re: Formula to return data from multiple columns

    That is amazing! Thank you!
    Reply With QuoteRegister To Reply
  6. 06-06-2017, 04:09 PM #6
    JeteMc
    JeteMc is offline
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,570

    Re: Formula to return data from multiple columns

    You're Welcome. Thank You for the feedback and for marking the thread as 'Solved'. I hope that you have a blessed day.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. VLOOKUP to return data from multiple columns
    By aj7298 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-20-2016, 05:06 PM
  2. Formula to return values in list from multiple columns
    By csunilkumar in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-12-2014, 04:29 AM
  3. [SOLVED] Return adjacent cell from formula with multiple columns
    By deluga.69 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 03-24-2014, 02:00 PM
  4. Want to lookup multiple matching criteria and return multiple data in columns
    By J Mercey in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 10-16-2013, 12:42 PM
  5. Need formula to return values from multiple columns from a dropdown
    By KRomin in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-14-2012, 03:54 AM
  6. return multiple columns/rows of data in formula?
    By darksoda in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-01-2007, 09:19 AM
  7. If value in data range (multiple columns) return row
    By flickflick in forum Excel General
    Replies: 0
    Last Post: 08-18-2006, 06:59 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1