Tracking Numbers In A Column

Hello all,

I am trying to track the numbers in BOX A under columns 1, 2 & 3 in the TRACKING chart.

Numbers are entered in the NUMBERS chart. The person will enter their first 3 numbers on line one going from left to right. (example - #1 - 7, 7, 24)
The next three numbers will be enter on line 2 starting left to right (example - #2 - 15, 3, 36) and so on all the way down to #11 in the numbers box.

Then under the TRACKING chart I want to how many times the numbers in BOX A come up in column 1, or column, or column 3 for the past three entries.

Thanks for your response Glenn. You are almost there. It works some of the time but not all of the time. In your spreadsheet you did capture the first two sequences correctly.

For the first series of #1 under NUMBERS 7,7,24 the TRACKING chart shows 2 in Column 1, which matches 7 showing up twice in column 1 in Chart A. The third number in the first series was 24. It correctly put one hit under the #2 Column under TRACKING because that matches 24 in the 2nd column under the CHART A.
That is the same for the 2nd series of three under NUMBERS with 15,3,36. 15 is under column 2 in TRACKING and under column 2 in CHART A. 3 is in column 1 under TRACKING which matches column 1 under CHART A. 36 is under column 3 in TRACKING which matches with column 3 under CHART A.

But in the 3 set of three under the NUMBERS heading the numbers are 2,21,23. The TRACKING score count shows 2 hits under the first column and 1 hit under the second column.

2 is in the first column under CHART A so that should record a 1 under column 1 in TRACKING. 21 & 23 are both under column 2 under CHART A so there should be a corresponding count of 2 under the #2 column in the TRACKING chart.

I am not quite sure where it takes that turn, and I am not quite sure how to fix it. I did attach a snapshot of what it should look like with the right counts under the TRACKING columns.

You are on the right path though, and I do greatly appreciate your help Glenn.

THAT IS PERFECT GLENN! Thank you very much!

As far as an older version of Excel I sure hope that is not the case. I had to get a new laptop last month so I had to buy Microsoft Office again last month as well. Microsoft better have sold me the latest and greatest version.

Thanks again so much for your help Glenn and have a great day!