+ Reply to Thread
Results 1 to 2 of 2

Extracting data from a list and creating new list

  1. #1
    Registered User
    Join Date
    04-29-2013
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    36

    Extracting data from a list and creating new list

    I'm trying to extract data from a list that meets certain criteria and put that info into a new list. If you look at the attached example the 2nd tab has registrations. Based on the registrations I would like to create separate lists for each group. Column A has which group they will be in. I would like the first name, last name and date of birth for everyone from Group 1 from the 2nd tab to show up in columns B, C, and D in the 1st tab "Evaluation- Group 1". Hopefully that makes sense after looking at the example.

    If possible, it would be nice to have it broken up by gender as well. So I would create another tab, 1 with "group 1 female" and another with "group 1 Male".

    Thanks for any help!
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor AZ-XL's Avatar
    Join Date
    03-22-2013
    Location
    Azerbaijan, Baku
    MS-Off Ver
    Excel 2007
    Posts
    603

    Re: Extracting data from a list and creating new list

    Hi
    b2 cell=
    =IFERROR(INDEX(Registrations!$B$2:$E$19,SMALL(IF($A$1=Registrations!$A$2:$A$19,ROW(Registrations!$A$2:$A$19)-1,""),ROW()-1),MATCH('Evaluation -Group 1'!B$1,Registrations!$B$1:$E$1,0)),"")
    Ctrl+Shift+Enter
    Appreciate the help? CLICK *

+ 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. Replies: 7
    Last Post: 06-12-2013, 07:09 PM
  2. [SOLVED] Taking a list of tasks and a list of subtasks and creating a new list with groupings
    By kknb0800 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 11-06-2012, 12:16 PM
  3. Replies: 2
    Last Post: 08-28-2012, 10:41 PM
  4. Replies: 4
    Last Post: 02-15-2012, 12:11 PM
  5. [SOLVED] Extracting desired data from a list when the Unwanted list is provided
    By all4excel in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 05-11-2008, 10:33 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1