+ Reply to Thread
Results 1 to 3 of 3

Extract data from a list to make an another summary list

  1. #1
    Registered User
    Join Date
    01-30-2013
    Location
    Coburg
    MS-Off Ver
    Excel 2010
    Posts
    22

    Extract data from a list to make an another summary list

    Hi attached is the excel sheet,in this sheet I have one table and its output. what formula I can use to get this output.
    Attached Files Attached Files

  2. #2
    Forum Guru AlKey's Avatar
    Join Date
    07-20-2009
    Location
    Lakeland, FL USA
    MS-Off Ver
    Microsoft Office 2010/ Office 365
    Posts
    8,904

    Re: Extract data from a list to make an another summary list

    Enter this formula in F5 and pull it to G5 and then down for list A

    =IFERROR(INDEX(A:A,AGGREGATE(15,6,ROW($B$5:$B$19)/(($B$5:$B$19<>0)),ROWS(A$5:A5))),"")

    For list B

    J5 and copy down

    =IFERROR(INDEX(A:A,AGGREGATE(15,6,ROW($C$5:$C$19)/(($C$5:$C$19<>0)),ROWS(A$5:A5))),"")

    in K5 and copy down

    =IFERROR(INDEX(C:C,AGGREGATE(15,6,ROW($C$5:$C$19)/(($C$5:$C$19<>0)),ROWS(B$5:B5))),"")
    If you like my answer please click on * Add Reputation
    Don't forget to mark threads as "Solved" if your problem has been resolved

    "Nothing is so firmly believed as what we least know."
    --Michel de Montaigne

  3. #3
    Registered User
    Join Date
    01-30-2013
    Location
    Coburg
    MS-Off Ver
    Excel 2010
    Posts
    22

    Re: Extract data from a list to make an another summary list

    Thanks a lot, It worked.
    What if I have to make list A & List B into a one list without the zero values.
    Means "List" of unique A and unique B in a one column and unique A & unique B values into second column.

+ 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: 2
    Last Post: 02-22-2015, 11:40 AM
  2. Replies: 4
    Last Post: 08-14-2013, 09:14 PM
  3. extract number values from a table and make a list
    By mischge in forum Excel General
    Replies: 27
    Last Post: 08-14-2013, 04:00 AM
  4. [SOLVED] make a summary list
    By kamelkid2 in forum Excel General
    Replies: 2
    Last Post: 03-27-2012, 08:55 AM
  5. Make data list and copy from a list
    By codepin in forum Excel General
    Replies: 5
    Last Post: 03-19-2009, 05:08 AM
  6. Logic- Extract Data into summary form from a list
    By Harlequin in forum Excel General
    Replies: 2
    Last Post: 02-01-2007, 07:09 AM
  7. Can I make a list, on one summary sheet, of data collected from ma
    By anamcara in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-15-2005, 07:10 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