JTL9161
Well-known Member
- Joined
- Aug 29, 2012
- Messages
- 591
- Office Version
- 365
- Platform
- Windows
Not sure if this is do-able or even clearly explain-able.
I have a fantasy baseball spreadsheet that calculates the number of correct daily picks for 20 people
I have each person picks labeled as the teams "2nd name" (i.e. Red Sox, Yankees, Mets, Dodgers)
I then have the scores from each day/nights games uploaded to my spreadsheet each morning.
They come over as team name in column A and # of runs in column B
I then with a IFERROR/VLOOKUP in column C label the teams with just their 2nd name to match what it is in the pick table
(A80) Chicago White Sox (B80) 1 (C80) White Sox
(A81) Boston Red Sox (B81) 0 (C82) Red Sox
This format is continued down for all the games results from the previous day
The example of the table is
(B1) Name (C1) Name (D1) Name
(B2) White Sox (C2) Red Sox (D2) Red Sox
Is there ANY logic (Conditional formatting?) that I can use that will check cells B80 & B81 and determine the higher score and then take the label of that higher scoring team in either cell C80 or C81 and put a 1 if they got it correct and a 0 if they didn't? In this case in cell B2 would be a "1" and C2 and D2 would be a "0". I have the columns totaled at the bottom to determine # of wins and # of losses.
Obviously I will copy this format through out my table for all participants and their picks. Just trying to save time by having the spreadsheet use the data I am uploading to it to tell me which person did or did not have the correct pick.
I'd though I try to see if anyone had any suggestions.
Thanks,
James
I have a fantasy baseball spreadsheet that calculates the number of correct daily picks for 20 people
I have each person picks labeled as the teams "2nd name" (i.e. Red Sox, Yankees, Mets, Dodgers)
I then have the scores from each day/nights games uploaded to my spreadsheet each morning.
They come over as team name in column A and # of runs in column B
I then with a IFERROR/VLOOKUP in column C label the teams with just their 2nd name to match what it is in the pick table
(A80) Chicago White Sox (B80) 1 (C80) White Sox
(A81) Boston Red Sox (B81) 0 (C82) Red Sox
This format is continued down for all the games results from the previous day
The example of the table is
(B1) Name (C1) Name (D1) Name
(B2) White Sox (C2) Red Sox (D2) Red Sox
Is there ANY logic (Conditional formatting?) that I can use that will check cells B80 & B81 and determine the higher score and then take the label of that higher scoring team in either cell C80 or C81 and put a 1 if they got it correct and a 0 if they didn't? In this case in cell B2 would be a "1" and C2 and D2 would be a "0". I have the columns totaled at the bottom to determine # of wins and # of losses.
Obviously I will copy this format through out my table for all participants and their picks. Just trying to save time by having the spreadsheet use the data I am uploading to it to tell me which person did or did not have the correct pick.
I'd though I try to see if anyone had any suggestions.
Thanks,
James