+ Reply to Thread
Results 1 to 6 of 6

Tracking Numbers In A Column

  1. #1
    Registered User
    Join Date
    04-13-2019
    Location
    Oregon, USA
    MS-Off Ver
    2016
    Posts
    20

    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.
    Attached Files Attached Files

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... based in Ireland... but I could be anywhere in the world
    MS-Off Ver
    Office 365 for PC.
    Posts
    33,870

    Re: Tracking Numbers In A Column

    Is this what you wanted???

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

    copied across and down.
    Attached Files Attached Files
    Glenn



  3. #3
    Registered User
    Join Date
    04-13-2019
    Location
    Oregon, USA
    MS-Off Ver
    2016
    Posts
    20

    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.
    Attached Images Attached Images

  4. #4
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... based in Ireland... but I could be anywhere in the world
    MS-Off Ver
    Office 365 for PC.
    Posts
    33,870

    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...
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    04-13-2019
    Location
    Oregon, USA
    MS-Off Ver
    2016
    Posts
    20

    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. #6
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... based in Ireland... but I could be anywhere in the world
    MS-Off Ver
    Office 365 for PC.
    Posts
    33,870

    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 !!

    3. Please take a moment to update your profile (shows 2010)

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

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. tracking numbers for etrade excel mgr.
    By wa6aik in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 12-09-2013, 03:47 PM
  2. Tracking serial numbers
    By blh in forum Excel General
    Replies: 10
    Last Post: 03-20-2012, 06:32 AM
  3. Dynamic Cell URL's from Tracking Numbers
    By mlafleur in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-10-2007, 01:59 AM
  4. Paste tracking numbers
    By grinninjen in forum Excel General
    Replies: 2
    Last Post: 05-15-2007, 03:33 PM
  5. Create column of tracking numbers from cells
    By wallyb in forum Excel General
    Replies: 2
    Last Post: 03-16-2007, 05:58 PM
  6. [SOLVED] How do I add tracking numbers to excel
    By Barbara in forum Excel General
    Replies: 1
    Last Post: 08-14-2006, 06:50 PM
  7. FedEx tracking numbers in Excel
    By Adam J in forum Excel General
    Replies: 0
    Last Post: 07-24-2006, 02:40 PM
  8. [SOLVED] How to insert tracking numbers into my webpage for RMA tracking
    By wiglady in forum Excel General
    Replies: 0
    Last Post: 04-04-2006, 07:45 AM

Bookmarks

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