Filling a matrix with records

[juanjoge]

Hello, I have a list of data that I want to use to fill a matrix, the interesting thing in this case is that I need to fill it with the values of one of the columns. In the example that I put in the image I managed to count with the function COUNT.IF.SET , the number of records that have the two conditions (hig and 2; Hig and 5; Modearado and 2; and Moderado and 5).

What I need is , to obtain the matrix where the names of the technologies according to the High or Moderate and the number of years are shown.


Thank you very much for your support

 

[6StringJazzer]

What is COUNT.IF.SET? That is not a standard Excel function.

What version of Excel are you using? Solution will vary depending on version. (I suggest you update your profile to show it.)

For later versions I would use this for each of the four quadrants, making the appropriate changes.

=FILTER(Table1[Technology],(Table1[Years To]=2)*(Table1[Benefit]="High"))

Get rid of the merged cells, they're nothing but bad news.

 

[juanjoge]

What is COUNT.IF.SET? That is not a standard Excel function.

What version of Excel are you using? Solution will vary depending on version. (I suggest you update your profile to show it.)

For later versions I would use this for each of the four quadrants, making the appropriate changes.

=FILTER(Table1[Technology],(Table1[Years To]=2)*(Table1[Benefit]="High"))

Get rid of the merged cells, they're nothing but bad news.

HI, many thanks , the version is 365- 2308

 

[juanjoge]

What is COUNT.IF.SET? That is not a standard Excel function.

What version of Excel are you using? Solution will vary depending on version. (I suggest you update your profile to show it.)

For later versions I would use this for each of the four quadrants, making the appropriate changes.

=FILTER(Table1[Technology],(Table1[Years To]=2)*(Table1[Benefit]="High"))

Get rid of the merged cells, they're nothing but bad news.

Works perfect, many many thanks!!!

 

[6StringJazzer]

Glad to help! Also I didn't know the name of your table but I guess you worked it out.