Hello

enumeration by vba or by matric or both



How to have this result either by vba or by matric

has data on 1000 rows in 2 series of combinations different lengths


ex: Series 1 columns A to D

1 2 7 5
1 2 5 7

Series 2 columns F to H

1 2 5 = 2
1 5 7 = 2
2 5 7 = 2
etc...

result in column J


Thank you