+ Reply to Thread
Results 1 to 4 of 4

Extract first cell in a row, given the column header and data point in that column.

  1. #1
    Registered User
    Join Date
    12-18-2012
    Location
    Here
    MS-Off Ver
    2016
    Posts
    10

    Extract first cell in a row, given the column header and data point in that column.

    I have a table of scores below, its a lot larger with more names, dates and scores in a sheet called 'Data'. Some cells may be blank, which I've marked below. I have formulas to extract the high score per person across all dates per a sheet called 'Personal Best'.

    I need to extract the date of the highest score per person given the name and high score (the earliest date, in the event of two tied high scores). Basically extract the first cell value in the row, given the column header and data point in that column. Since the table is quite large, if you can assume say 1000 rows and columns out to BB, that would be helpful. Thank you in advance for any help!!

    Personal Best sheet
    A5: Adam
    B5: 199
    C5: [extract date]

    A6: Bob
    B6: 214
    C6: [extract date] - note: ability to copy the formula down for other names/scores


    Data sheet

    (blank) (blank) (blank) Adam Bob John Mike Joe
    10/4/12 info Game 1 (blank) 177 193 (blank) 124
    10/4/12 info Game 2 (blank) 192 128 (blank) 156
    10/4/12 info Game 3 (blank) 202 158 (blank) 193
    10/4/12 info Game 4 (blank) 155 169 (blank) 164
    10/4/12 info Game 5 (blank) 214 192 (blank) 160
    10/4/12 info Game 6 (blank) 200 208 (blank) 191
    10/4/12 info Game 7 (blank) 182 226 (blank) 134
    10/11/12 info Game 1 113 202 150 169 (blank)
    10/11/12 info Game 2 146 159 144 150 (blank)
    10/11/12 info Game 3 120 134 194 117 (blank)
    10/11/12 info Game 4 138 119 175 145 (blank)
    10/11/12 info Game 5 161 178 158 131 (blank)
    10/11/12 info Game 6 199 151 142 182 (blank)
    10/11/12 info Game 7 166 180 144 162 (blank)
    10/18/12 info Game 1 150 186 164 184 (blank)
    10/18/12 info Game 2 158 166 172 153 (blank)
    10/18/12 info Game 3 130 157 202 146 (blank)
    10/18/12 info Game 4 135 188 215 146 (blank)
    10/18/12 info Game 5 113 202 150 169 (blank)
    10/18/12 info Game 6 146 159 144 150 (blank)
    10/18/12 info Game 7 (blank) (blank) (blank) (blank) (blank)

  2. #2
    Forum Expert
    Join Date
    09-01-2012
    Location
    Norway
    MS-Off Ver
    Office 365
    Posts
    2,844

    Re: Extract first cell in a row, given the column header and data point in that column.

    Something like this then?
    Attached Files Attached Files
    <----- If you were helped by my posts you can say "Thank you" by clicking the star symbol down to the left

    If the problem is solved, finish of the thread by clicking SOLVED under Thread Tools
    I don't wish to leave you with no answer, yet I sometimes miss posts. If you feel I forgot you, remind me with a PM or just bump the thread.

  3. #3
    Registered User
    Join Date
    12-18-2012
    Location
    Here
    MS-Off Ver
    2016
    Posts
    10

    Re: Extract first cell in a row, given the column header and data point in that column.

    That did it, thank you so much!!

  4. #4
    Forum Expert
    Join Date
    09-01-2012
    Location
    Norway
    MS-Off Ver
    Office 365
    Posts
    2,844

    Re: Extract first cell in a row, given the column header and data point in that column.


    --------

+ 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. [SOLVED] Extract the column header given the row header and highest value in a subset of a table
    By pguarino in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 09-20-2013, 02:05 AM
  2. [SOLVED] Sort by column E, and create sheets named by that column, add header and data
    By salaso69 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-24-2012, 12:42 AM
  3. Replies: 2
    Last Post: 08-09-2012, 09:16 AM
  4. Replies: 3
    Last Post: 02-08-2010, 06:18 PM
  5. Replies: 1
    Last Post: 05-02-2008, 04:57 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