+ Reply to Thread
Results 1 to 6 of 6

Text value in an interference matrix

  1. #1
    Registered User
    Join Date
    11-24-2022
    Location
    France
    MS-Off Ver
    Office 365
    Posts
    11

    Lightbulb Text value in an interference matrix

    Hello everyone,
    First I would like to apologize for this obscure title. If you have any suggestion, i'll take it.

    I have data that presents itself in two columns. The first column is what I call the "systems", the second one can be the "features".
    For each system (S1, S2, S3, ...) there is one or more features associated (F1, F2, F3, ...).

    Ex:

    System Feature
    S1 F1
    S1 F2
    S1 F3
    S2 F1
    S2 F4

    My colleague wants to display which system has different associations of two features. He thought about the output as a table with n lines and n columns (n being the number of features). Then at each intersection, there would be the list of systems that has this association of features.
    For example, with the previous the table the result would be like so :

    Capture.PNG

    Since S1 and S2 both have F1 in common, they both end up in the F1-F1 cell.
    And because only S1 has F2 and F1, it's the only value in F2-F1.

    We both got stumped by this problem and couldn't find an easy solution.

    Do you see any way we could approach this?

    Thanks.

  2. #2
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Cool Re: Text value in an interference matrix

    just for fun with Power Query or Pivot Table. Are you interested in ?

    System Feature Feature F1 F2 F3 F4 sys
    S1 F1 F1 S1,S2 F1 F2 F3 F4
    S1 F2 F2 S1 F1 S1, S2
    S1 F3 F3 S1 F2 S1
    S2 F1 F4 S2 F3 S1
    S2 F4 F4 S2
    Last edited by sandy666; 11-24-2022 at 12:02 PM. Reason: changed layout

  3. #3
    Registered User
    Join Date
    11-24-2022
    Location
    France
    MS-Off Ver
    Office 365
    Posts
    11

    Re: Text value in an interference matrix

    Hello Sandym
    Thank you for your answerm i had a gut feeling pivot could help but i played with the options a little and i must be missing out on something.
    I can't display the system names, only operations on the amount of systems.
    Is there any way to display the strings ?
    Thanks !

  4. #4
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Cool Re: Text value in an interference matrix

    insert Pivot Table but use

    creatept.png

    in Data Model duplicate Feature column

    next add Measure to the table

    addmeasure.png

    then set Measure

    measure.png

    next add Feature to the ROWS area, duplicated column to the COLUMNS area and Measure to the VALUES area

    areas.png

    that's all folks

  5. #5
    Registered User
    Join Date
    11-24-2022
    Location
    France
    MS-Off Ver
    Office 365
    Posts
    11

    Re: Text value in an interference matrix

    Hello Sandy and thank you for the detailed answer
    However it looks like the pivot table only populates the diagonal?
    For example, I will only see the systems that share the F1 feature, but I will not see the ones that have F2 and F1 in common.

    If you look at my first post, you can see the end result does not only have values in the diagonal.

    I should have said so after your first post, my bad

  6. #6
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: Text value in an interference matrix

    F1 to F1 is S1, S2
    F2 to F2 is S1
    and so on

    if you have the same headers and labels the result will be diagonal, this is your choice from post#1

+ 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. [SOLVED] Macro interference
    By Programmernovice in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 09-28-2021, 11:22 AM
  2. VBA Code & Formula Interference
    By agroeneveld in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-11-2016, 05:51 PM
  3. How to protect against user interference...
    By Legend Rubber in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-21-2012, 09:28 AM
  4. Interference between Macros?
    By RDS in forum Excel General
    Replies: 1
    Last Post: 02-20-2012, 06:00 AM
  5. Interference between 2 ComboBox
    By Magic_Doctor in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-20-2011, 03:38 PM
  6. Sheet Protection Interference
    By jomili in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-19-2011, 11:53 AM
  7. [SOLVED] dragging without interference
    By BorisS in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-20-2005, 04:06 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