+ Reply to Thread
Results 1 to 3 of 3

Creating Selection of Rows by Multiple Criteria

  1. #1
    Registered User
    Join Date
    05-19-2013
    Location
    Chester, England
    MS-Off Ver
    Excel 2013
    Posts
    40

    Creating Selection of Rows by Multiple Criteria

    I have a list of names - each belonging to one of 6 Groups. Each name has a series of 3 tasks undertaken 6 times.
    I want to be able to select a particular task of the 18 possible - and see a list of only those names in that group along with their results for all 6 of the type of task selected.
    The attached workbook should make this clearer.
    Thanks, as ever, for any assistance.
    Attached Files Attached Files

  2. #2
    Forum Expert Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    Thailand
    MS-Off Ver
    MS 365
    Posts
    3,765

    Re: Creating Selection of Rows by Multiple Criteria

    Not sure I get this right.

    Please try
    B4
    =IF(C4="","",INDEX(Data!B:B,AGGREGATE(15,6,ROW(Data!$C$3:$C$28)/(Data!$C$3:$C$28=2),ROWS(B$4:B4))))
    C4
    =IF(ROWS(C$4:C4)>COUNTIF(Data!C:C,RIGHT($B$1)),"",--RIGHT($B$1))
    D4:I4
    =IF($C4="","",INDEX(Data!$D$3:$U$28,MATCH($B4,Data!$B$3:$B$28),MATCH(LEFT($B$1,FIND(" ",$B$1))&D$3,Data!$D$2:$U$2,))&"")
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    05-19-2013
    Location
    Chester, England
    MS-Off Ver
    Excel 2013
    Posts
    40

    Re: Creating Selection of Rows by Multiple Criteria

    Bo,
    Many thanks - works perfectly, does exactly what I want.

+ 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: 18
    Last Post: 10-21-2017, 12:37 AM
  2. [SOLVED] VBA Change Event, Move multiple rows based on drop down selection for multiple criteria
    By Webbers in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-02-2017, 11:51 AM
  3. [SOLVED] Return multiple values (matrice) by selection of multiple criteria.
    By toman159 in forum Excel General
    Replies: 6
    Last Post: 11-28-2016, 11:05 AM
  4. Select a cell at random based on multiple selection criteria across multiple sheets.
    By scottyms in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-03-2016, 09:44 AM
  5. How to count the number of rows that meet multiple selection criteria
    By mcnallyb in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-21-2014, 11:26 AM
  6. creating a selection list out of variable criteria
    By w42 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-11-2014, 04:34 AM
  7. Multiple selection criteria, which formula? .. and selection based on unique numbers
    By FalkirkJim in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-11-2012, 05:22 PM

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