# Tracking Numbers In A Column

1. ## 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.

2. ## Re: Tracking Numbers In A Column

Is this what you wanted???

=COUNTIF(\$G\$6:\$I\$16,B5)

copied across and down.

3. ## Re: Tracking Numbers In A Column

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.

4. ## Re: Tracking Numbers In A Column

Actually, I was MILES out....

=SUM(IF(ISNUMBER(MATCH(\$G6:\$I6,B\$5:B\$16,0)),1,0))

You seem to be using an older version of Excel than me. So, please refer to the attached file. If the formulae are enclosed within a pair of { }, these are array formulae.

These are a little different from ordinary formulae in that they MUST be confirmed in the FIRST CELL ONLY by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. After that, the array can be dragged down as normal, to cover the desired range.

You will know the array is active when you see the curly brackets { } appear around the outside of your formula. If you do not use CTRL+SHIFT+ENTER you will (almost always) get an error message or an incorrect answer. Press F2 on that cell and try again.

Don't type the curly brackets yourself - it won't work...

5. ## Re: Tracking Numbers In A Column

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!

6. ## Re: Tracking Numbers In A Column

1. If you now have 0365, you won't need to use an arry entry.

2. If something else... you will !!

4. You're welcome & thanks for the feedback.

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1