Attached, please find excel file to show data.
I have a variety of patterns in cells B:G as follows:
0 1 0 1 0 0
0 0 0 0 0 1
1 0 0 0 1 1
0 1 0 1 0 0
etc..
Need help with a vba to find patterns and list them separately in new cells (L:Q) and their frequencies, as indicated in the file.
Thanks.
Bookmarks