Creating dependent list with Criterias

[Nicolantonio]

Hello,

Just a quick question.
In the excel doc, you will see that There are 2 tables with 2 lists.
The first table contains Names, number of times for the name to repeat itself, and the Language.

So with the following formula i cant have the names repeat in a list based on the amount of times i state on the table.

I have managed to do so with the following formula in cell A17:

=IFERROR(INDEX(Dashboard!$A$4:$A$14,MATCH(0,INDEX(--(COUNTIF($A$16:A16,Dashboard!$A$4:$A$14)=Dashboard!$B$4:$B$14),0),0)),"")


What I want to do now, is create a following list that is suppose to be right next to the first one, which is suppose to do the same thing, but it cant have the same name in the same row, and the names have to have the same language.

So basically the second list has to depend on the first to do the same thing but with these additional requirements:
-The names in the two lists cant have the same name in the same row.
-The name in list 2 has to have the same langauge as the one in list one.

So basically same list but without matching row names, and matching language.


I hope my silly explanation makes sense.


Here is an example:

List a List b
a b
a b
b c
b c
c d
c d
d a
d a
But for example the name a in list A, and b in list B are both the same language.


I tried to do something like this:
=INDEX($A$16:$AA$4000,AGGREGATE(15,6,ROW($A$16:$AA$4000)/(($A$16:$AA$4000 <>$B16)*(COUNTIF($B$16:$B4000,$A$16:$AA$4000)=0)*($B$16:$B4000=INDEX($C$10:$C$30,MATCH($AA2,$A$10:$A$30,0),))),COUNTIF($AA$2:$AA2,$AA2)))


But i know that allot is wrong in this formula.
I thought maybe by filtering.

Because this formula works brilliantly and gives me the repeated values:
=IFERROR(INDEX(Dashboard!$A$4:$A$14,MATCH(0,INDEX(--(COUNTIF($A$16:A16,Dashboard!$A$4:$A$14)=Dashboard!$B$4:$B$14),0),0)),"")


I just dont know how to add a condition to not have the same value in the same row...

[Nicolantonio]

I tried to do something like this:
=INDEX($A$16:$AA$4000,AGGREGATE(15,6,ROW($A$16:$AA$4000)/(($A$16:$AA$4000 <>$B16)*(COUNTIF($B$16:$B4000,$A$16:$AA$4000)=0)*($B$16:$B4000=INDEX($C$10:$C$30,MATCH($AA2,$A$10:$A$30,0),))),COUNTIF($AA$2:$AA2,$AA2)))


But i know that allot is wrong in this formula.
I thought maybe by filtering.

Because this formula works brilliantly and gives me the repeated values:
=IFERROR(INDEX(Dashboard!$A$4:$A$14,MATCH(0,INDEX(--(COUNTIF($A$16:A16,Dashboard!$A$4:$A$14)=Dashboard!$B$4:$B$14),0),0)),"")


I just dont know how to add a condition to not have the same value in the same row...