+ Reply to Thread
Results 1 to 3 of 3

Matching of two conditions with multiple output criteria (SOD-Finance)

  1. #1
    Registered User
    Join Date
    01-26-2017
    Location
    Munich
    MS-Off Ver
    2016
    Posts
    9

    Matching of two conditions with multiple output criteria (SOD-Finance)

    20170127_SOD Conflicts.PNG

    Dear All,

    I am currently working on an internal SOD (Separation of Duties) project. As I am not very versed in Excel I am having problems identifying a way to solve this issue with a smart formula.
    Would be wonderful if one of you Excel experts could help.


    Issue:

    - I have a list with (many individual) users
    - Each user has a number of tasks he/she can perform
    - These tasks may or may not conflict with each other
    - Conflicting tasks are listed in a table (see from picture/Excel expert)

    Goal:
    - Find a formula, which will identify the conflicting tasks, such that the cell tells me, which tasks is the conflicting one (as listed in the table)

    Problem:
    - Find appropriate formula that lists the corresponding (conflicting) action on the left
    - There are Actions which are conflicting with more than one action:
     Is it possible, to have the formula return i.e. “Action Y” and “Action C” etc.?
     Or is this something I will have to try to solve with Access/not Excel?

  2. #2
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    365
    Posts
    7,908

    Re: Matching of two conditions with multiple output criteria (SOD-Finance)

    A lot will depend on how the data are laid out.

    Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
    One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.

    A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.

  3. #3
    Registered User
    Join Date
    01-26-2017
    Location
    Munich
    MS-Off Ver
    2016
    Posts
    9

    Re: Matching of two conditions with multiple output criteria (SOD-Finance)

    The issue at hand has been on hold for a while, so I just checked. The solution seems great. I will try it out and report back.
    Thank You for the speedy response!

+ 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. matching multiple cells to output one value
    By chefbilly in forum Excel General
    Replies: 4
    Last Post: 03-27-2016, 07:17 AM
  2. Meeting Multiple Conditions In A Table For Unique Output
    By Billy Corman in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-01-2015, 04:52 AM
  3. [SOLVED] Multiple Criteria to get Particular Output
    By mphillips in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 05-01-2015, 09:39 AM
  4. Distribute/Copy by Matching Multiple Conditions
    By decentboy in forum Excel Programming / VBA / Macros
    Replies: 25
    Last Post: 12-12-2014, 04:55 PM
  5. Replies: 5
    Last Post: 02-29-2012, 10:39 AM
  6. Count rows matching multiple conditions
    By robert_mim in forum Excel General
    Replies: 4
    Last Post: 11-18-2009, 11:23 AM
  7. SUMIF or an array formula - matching multiple conditions
    By Jason_2112 in forum Excel General
    Replies: 2
    Last Post: 01-14-2009, 06:03 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