+ Reply to Thread
Results 1 to 4 of 4

Formula to create list of items selected for reports (array formula?)

  1. 04-06-2018, 01:23 AM #1
    Cidona
    Cidona is offline
    Forum Contributor
    Join Date
    04-27-2010
    Location
    Kinsale, Ireland
    MS-Off Ver
    Excel 2010
    Posts
    129

    Formula to create list of items selected for reports (array formula?)

    Dear Forum.
    Would very much appreciate if someone could help me out with an array formula. At least I believe it requires an array formula.
    On the attached workbook there are two sheets – “DataInfo” and “PrintReport”. On the “DataInfo” sheet in cells F13:K18 there is information. Column F indicates where I want this to show up in the “PrintReport” sheet (Yes or No Data validation).
    So, on sheet “Print Report in cells G14:K18 I would like formula to return relevant values for those that were selected as “Yes” in the “DataInfor” sheet.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 04-06-2018, 01:51 AM #2
    FDibbins
    FDibbins is offline
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,926

    Re: Formula to create list of items selected for reports (array formula?)

    Try this in G2, copied down and across as needed...
    =IFERROR(INDEX(DataInfo!G:G,SMALL(IF(DataInfo!$F$14:$F$18="Yes",ROW(DataInfo!$F$14:$F$18)),ROWS($A$1:A1))),"")
    ARRAY entered (you were correct), using CTRL SHIFT ENTER
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford
    Reply With QuoteRegister To Reply
  3. 04-06-2018, 02:06 AM #3
    Cidona
    Cidona is offline
    Forum Contributor
    Join Date
    04-27-2010
    Location
    Kinsale, Ireland
    MS-Off Ver
    Excel 2010
    Posts
    129

    Re: Formula to create list of items selected for reports (array formula?)

    That works perfect FDibbins and in the actual workbook is a beautiful feature.

    Thank you very much for your extremely helpful and quick response!!
    Reply With QuoteRegister To Reply
  4. 04-06-2018, 02:09 AM #4
    FDibbins
    FDibbins is offline
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,926

    Re: Formula to create list of items selected for reports (array formula?)

    Im happy to help Thanks for the kin words and feedback!
    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. To create a list of items in which certain items can be selected and printed
    By swashbuckler in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 03-05-2017, 01:26 PM
  2. array within an array to discount selected items from formula
    By Hub101 in forum Excel General
    Replies: 4
    Last Post: 05-26-2016, 09:30 AM
  3. Array formula to return list of unique items from selected columns only
    By jlawton1 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-23-2016, 04:53 AM
  4. [SOLVED] formula to create list of unique items
    By pink in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 12-13-2014, 02:29 AM
  5. [SOLVED] Using an array to create a list of selected items
    By Harribone in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-02-2014, 04:40 PM
  6. Formula to Sum values of items selected in a Data Validation List.
    By zicitron in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-30-2013, 04:49 PM
  7. Cannot get a formula array to return the correct count of list items
    By macyarab in forum Excel General
    Replies: 10
    Last Post: 01-21-2012, 06:03 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