+ Reply to Thread
Results 1 to 9 of 9

Match 3 criteria + stacks in top of each other

  1. #1
    Forum Contributor
    Join Date
    10-28-2010
    Location
    quebec, canada
    MS-Off Ver
    o365
    Posts
    187

    Match 3 criteria + stacks in top of each other

    Hi,

    I've got data in few cell that i want to match.

    A:A = names (results)
    B:B = Status (match specific)
    D:D = Schedule (Match E5)

    So in E5 i've got a schedule. Under E5 (e6 e7 etc), i want to Match the schedule in (E5 match in D:D), if a match is found, it needs to match the second criteria in B:B, needs to match "SBK". If both results are found and match, E6 will contain the A:A data (name). And it needs to go to the next row and do the search again for the next name.

    I need to be able to reproduce this formula in E6(different schedule) and ++

    Is it clear enough?

  2. #2
    Forum Expert 63falcondude's Avatar
    Join Date
    08-22-2016
    Location
    USA
    MS-Off Ver
    365
    Posts
    6,266

    Re: Match 3 criteria + stacks in top of each other

    Please attach a sample workbook. Make sure there is just enough data to demonstrate your need.
    Make sure your desired results are shown, mock them up manually if necessary.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

  3. #3
    Forum Contributor
    Join Date
    10-28-2010
    Location
    quebec, canada
    MS-Off Ver
    o365
    Posts
    187

    Re: Match 3 criteria + stacks in top of each other

    There we go
    Attached Files Attached Files

  4. #4
    Forum Expert 63falcondude's Avatar
    Join Date
    08-22-2016
    Location
    USA
    MS-Off Ver
    365
    Posts
    6,266

    Re: Match 3 criteria + stacks in top of each other

    Try this:

    E6 =IFERROR(INDEX($A$4:$A$64,SMALL(IF($D$4:$D$64=E$5,ROW($A$4:$A$64)-(ROW($A$4)-1)),ROWS($A$1:$A1))),"") Ctrl Shift Enter

  5. #5
    Forum Contributor
    Join Date
    10-28-2010
    Location
    quebec, canada
    MS-Off Ver
    o365
    Posts
    187

    Re: Match 3 criteria + stacks in top of each other

    It does work, but it does not take account what's in B:B (sbk), it will not all be SBK

  6. #6
    Forum Expert 63falcondude's Avatar
    Join Date
    08-22-2016
    Location
    USA
    MS-Off Ver
    365
    Posts
    6,266

    Re: Match 3 criteria + stacks in top of each other

    Simple enough addition. try this:

    =IFERROR(INDEX($A$4:$A$64,SMALL(IF(($B$4:$B$64="SBK")*($D$4:$D$64=E$5),ROW($A$4:$A$64)-(ROW($A$4)-1)),ROWS($A$1:$A1))),"") Ctrl Shift Enter

  7. #7
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2021
    Posts
    8,904

    Re: Match 3 criteria + stacks in top of each other

    E6=iferror(index($a:$a,small(index((($d$4:$d$64<>e$5)+($b$4:$b$64<>"sbk"))*10^10+row($d$4:$d$64),0),rows($e$6:$e6))),"")
    try this and copy across
    Samba

    Say thanks to those who have helped you by clicking Add Reputation star.

  8. #8
    Forum Contributor
    Join Date
    10-28-2010
    Location
    quebec, canada
    MS-Off Ver
    o365
    Posts
    187

    Re: Match 3 criteria + stacks in top of each other

    Nice let me try this one

    thanks

  9. #9
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2021
    Posts
    8,904

    Re: Match 3 criteria + stacks in top of each other

    OR CAN MODIFY "63falcondude" Formula
    AS
    =IFERROR(INDEX($A:$A,SMALL(IF(($B$4:$B$64="SBK")*($D$4:$D$64=E$5),ROW($A$4:$A$64)),ROWS($A$1:$A1))),"")

+ 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: 1
    Last Post: 02-11-2013, 04:39 AM
  2. Draw a waterfall chart using VBA - make stacks transparent
    By NiceLittleRabbit in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 02-08-2012, 08:52 AM
  3. [SOLVED] Problem with stacks and runtime failures
    By JimDandy in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-26-2010, 04:46 PM
  4. making stacks with percentage
    By wviveen in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 04-06-2009, 06:23 AM
  5. making stacks with percentage
    By sverre in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 04-03-2009, 08:59 AM
  6. Creating two stacks in one bar
    By nandhamnk in forum Excel Charting & Pivots
    Replies: 9
    Last Post: 02-08-2008, 09:24 AM
  7. How to Prevent Overlapping Stacks
    By robertguy in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 07-27-2007, 04:11 AM
  8. [SOLVED] Muliple Userforms and multiple Stacks
    By Peter T in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-05-2005, 12:06 PM

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