detect in each group, and add quantity, and assemble the list of two colors,
* the two color lists are all possible combinations, the macro will see the frequency of each formation in the two color list,
* the yellow and blue lists are all possible formations
https://www.excelforum.com/attachmen...1&d=1567950066
Bookmarks