sorting scores

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to sort the following teams scores for them to appear as the
winner first and the loser second. The original information is downloaded
from the season draw and appears in a set format as Team A Vs Team B but I
want to then sort into the winner and loser ie if Team A has a loss I want it
to appear second and Team B to appear first.
My spread sheet reads as follows: (Column A is Date, Column B is Time,
Column C is Court, Column D is the Division)
Column "E" is Team Name, Column F is the score for the team in column E

Column "G" is the opposing team name and Column H is the score for the team
in column G.

Can anybody help?

Thanks
 
You can't use Excel's standard sorting functionality to do what you want.

How would you feel about leaving the data in place but putting the winning
team's name in bold-face type? You can do that simply with Conditional
Formatting. Assuming your data starts in row 2,
1) select cell E2, then go to Format>Conditional Formatting
2) choose 'Formula is' and enter the formula =F2>H2
3) click on the format button and select the Bold font - or some other
formatting that sets the winner apart, then click on OK until you return to
the spreadsheet
4) select cell G2 and repeat, but use the formula =H2>F2
5) copy the formats for these two cells down the column

Alternatively, move the data in columns E thru H well off to the right, into
columns L:O, then use these formulas in E2:h2

E2: =if(m2>o2,l2,n2)
F2: =if(m2>o2,m2,o2)
G2: =if(m2<o2,l2,n2)
H2: =if(m2<o2,m2,o2)
 
Thanks for your help. I will go with the second option. The reason for the
sort is that the newspaper we send the results to lists the winner first: ie
Winner d Loser.
 
Back
Top