Results 1 to 8 of 8

ID# Column Needs to Match the Line Number to the Score in the Score Column

Threaded View

  1. #1
    Registered User
    Join Date
    12-04-2018
    Location
    Washington State, USA
    MS-Off Ver
    Microsoft Office 365
    Posts
    64

    ID# Column Needs to Match the Line Number to the Score in the Score Column

    I am attaching a worksheet that shows random triple scores. My problem is the ID# column CC. It not only matches and shows the ID# for the triple scores, but it is showing additional numbers. I do not know where these numbers come from and I do not want them. I only want it (Column CC) to show ID#s (line numbers) for the actual triple scores. I am sure it is something that I am just not seeing since, I have used the same formula for the consecutive scores and have changed the column letters. Another set of eyes will be appreciated.

    Here is what I am trying to do. Column CB are scores taken from Column T and are listed in Column CB largest to smallest. Column CC are the line numbers for only those scores shown in Column CB. Column CD shows the position of the person in the list in Column AG. Then Column CE is the Full Name. Columns CC and CD should work the same way that Columns CH and CI

    All of you who have helped me prepare this worksheet have provided tremendous help and learning. Thank you.
    Attached Files Attached Files
    Last edited by viclea; 10-23-2021 at 11:41 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Finding Triple and Consecutive Scores
    By viclea in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-10-2021, 05:03 PM
  2. Need to enter test scores and return suggestions based on those scores
    By deborahlane in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 10
    Last Post: 09-28-2020, 01:23 PM
  3. Transpose rows to columns and sort by scores (with repetitive scores)
    By anishmalhotra in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 07-02-2019, 08:17 PM
  4. [SOLVED] I need a macro to select range of scores, choose the best scores and apply a formula
    By hadleedog in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-12-2015, 03:15 PM
  5. Replies: 8
    Last Post: 12-20-2014, 04:37 PM
  6. Replies: 1
    Last Post: 06-15-2013, 09:02 PM
  7. VB macro for sorting through scores and copying certain scores to new sheet
    By cowboy713 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-23-2010, 01:47 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