Pedro
asked on
Show Team with Wins/Losses data
Hi everyone,
On the attached file on the page "Current Game 2" sheet, I would like to see the teams wins losses as follows:
S:T shows team with most wins
S = team name (taken from 'B' or 'J' row)
T = value on the bottomost wins column (taken from 'C' or 'K')
U:V shows team with least losses
U= team name (taken from 'B' or 'J' row)
V = value on the bottomost loss column (taken from 'D' or 'L')
In case any value is "Zero" then neither team is put in. That is both have the same value of zero.
For illustration purposes,
Cell C8 = 1 thus S6 = 'OAK' and T6 = 1
Cell L8 = (1) thus U6= 'KC' and V6 = (1). NOTE: '(1)' = negative one. This denotes less losses.
Cell C12 = 1 thus S7 = 'SF' and T7 = 1
Cell L12 = (1) thus U7= 'PIT' and V7 = (1). NOTE: '(1)' = negative one. This denotes less losses.
Cell C16 = 1 thus S8 = 'DET' and T8 = 1
Cell C16 = (1) thus U8= 'DET' and V8 = (1). NOTE: '(1)' = negative one. This denotes less losses.
Cell C20 = 2 thus S9 = 'LAA' and T9 = 2
Cell C20 = (1) thus U9= 'LAA' and V9 = (1). NOTE: '(1)' = negative one. This denotes less losses.
etc, etc,
When the values are 'zero' then no team or score is put in the cell as occurs in S12, S13, T12, T13 for the ATL:PHI and MIN:DET teams.
NOTE: Cells S6:V13 have been filled in manually to illustrate what the code should do.
EE-gamestats-W-L.xlsm
On the attached file on the page "Current Game 2" sheet, I would like to see the teams wins losses as follows:
S:T shows team with most wins
S = team name (taken from 'B' or 'J' row)
T = value on the bottomost wins column (taken from 'C' or 'K')
U:V shows team with least losses
U= team name (taken from 'B' or 'J' row)
V = value on the bottomost loss column (taken from 'D' or 'L')
In case any value is "Zero" then neither team is put in. That is both have the same value of zero.
For illustration purposes,
Cell C8 = 1 thus S6 = 'OAK' and T6 = 1
Cell L8 = (1) thus U6= 'KC' and V6 = (1). NOTE: '(1)' = negative one. This denotes less losses.
Cell C12 = 1 thus S7 = 'SF' and T7 = 1
Cell L12 = (1) thus U7= 'PIT' and V7 = (1). NOTE: '(1)' = negative one. This denotes less losses.
Cell C16 = 1 thus S8 = 'DET' and T8 = 1
Cell C16 = (1) thus U8= 'DET' and V8 = (1). NOTE: '(1)' = negative one. This denotes less losses.
Cell C20 = 2 thus S9 = 'LAA' and T9 = 2
Cell C20 = (1) thus U9= 'LAA' and V9 = (1). NOTE: '(1)' = negative one. This denotes less losses.
etc, etc,
When the values are 'zero' then no team or score is put in the cell as occurs in S12, S13, T12, T13 for the ATL:PHI and MIN:DET teams.
NOTE: Cells S6:V13 have been filled in manually to illustrate what the code should do.
EE-gamestats-W-L.xlsm
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Goflow,
That is it!
It looks like I posted a workbok then made changes to it before I posted the examples. But, the results I got match the expected results based on the table data.
Thanks Again!
That is it!
It looks like I posted a workbok then made changes to it before I posted the examples. But, the results I got match the expected results based on the table data.
Thanks Again!
Your welcome. I will keep this question monitored case you need more help in this subject pls let me know by putting a link in here.
gowflow
gowflow
you mentioned that you want S:T shows team with most wins then as per your data the most wins do not match with the manually filled codes as per your "NOTE: Cells S6:V13 have been filled in manually to illustrate what the code should do."