Identifying correlations within row & counting no. of times it appear within array

Edited:

My objective is to understand how much each pattern is in correlation with another pattern within the rows and subsequently how many times that same correlation occurs within array of B:N

e. g row no 1 would have had correlations between patterns 19 with 232, 19 with 126, 19 with 45, 19 with 467 and counting only row 1, it would be a count of 1 for each pattern.
if 19 with 232 is found again somewhere further down in another row, the calculation would pick up and display 2 counts of this combination.

One way is by exhibiting through the output table sheet that i have attached in the workbook but i would welcome any opinion!

Thanks alot!

Paul

The narrative says 'pattern' but the sample indicates 'value', so what is the real data being counted? A pattern comparison would return all two numerical digit entries for a the green value '87'. Where if values were compared only those matching '87' would be returned.

(How to) Upload a Workbook directly to the Forum
(please do not post pictures or links to worksheets)

• Click Advanced next to "Post Quick Reply" button at the bottom right of the editor box.
• Scroll down until you see "Manage Attachments",
• Click the "Choose" button at the upper left (upload from your computer).
• Select your file, click "open", click "upload"
• Once the upload is completed the file name will appear below the input boxes in this window.
• Close the Attachment Manager window.
• Click "Submit Reply"

Note: Please do not attach password protected workbooks/worksheets
Ensure to disable any Workbook Open/Autorun macros before attaching!

---

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

To change a Title go to your first post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 6)

Hello Paul and Welcome to Excel Forum.
Thank You for changing the title.
Like JLGWhiz, I am confused as to the objective. I feel that the best way is to demonstrate what you want by uploading a much smaller 'Patterns' table, perhaps 5 rows by 5 columns, using numbers 1 to 10. Then manually fill in the values in the corresponding output table as you would expect them to be displayed. We may then attempt to replicate your output using formulas/code, which you would then, hopefully, be able to apply to your actual data.
Let us know if you have any questions.