combine sector 1 with sector 2 and with sector 3. but it cannot have a repeated number.

[jorel]

combine sector 1 with sector 2 and with sector 3. but it cannot have a repeated number.
objective is to always cross the three sectors adding 15 numbers without having repetitions =
ex= sector 1 has 01 02 05 06 with sector two 06 07..
it cannot because it repeats the number 06, when the macro combines and has repeated numbers, you have to exclude the
line
always the crossing is sector 1 with sector 2 and with sector 3 adding 15 numbers
https://www.excelforum.com/attachmen...1&d=1691840837

[JEC.]

So what is your expected outcome? All lines which are allowed?

[JEC.]

Please Login or Register  to view this content.

[jorel]

hello,ok jec, thanks, for seeing the post, yes they are all the lines crossing in the three sectors, but it cannot have repeated numbers, in the line,
yes they are all the lines of sector1 with sector2 and with sector3, amacro will filter the lines with repetition of numbers and exclude

[JeteMc]

If I understand correctly, then this is a way to get the rows using formulas.
1. Fill column R using: =MAX(FREQUENCY(A6:Q6,A6:Q6))=1
2. Fill columns AK:BA using: =IFERROR(INDEX(A$6:A$131,AGGREGATE(15,6,(ROW(A$6:A$131)-ROW(A$5))/($R$6:$R$133=TRUE),ROWS(AK$6:AK6))),"")
3. Apply the following formatting to columns AK:BA 00;;
Let us know if you have any questions.

[jorel]

hello jeteMC, almost there, the macro has to combine all of sector 1 with sector two and with sector 3, it has to combine THE THREE COLUMNS OR THE THREE SECTORS
The sum of the sectors must give 15 numbers
goal is to eliminate repeated numbers in each line
I already tried to combine 126x7126x 126 sectors1x2x3
but with a lot of repetition of numbers the macro will do precisely this to filter the lines that have repeated numbers

[jorel]

hello jeteMec almost there, the way you did it was in a straight line, you have to combine the 1st sector with all the formations of the 2nd sector 126x1716 and then with the third sector, not in a straight line is wrong
126x7116x126= 1x2x3