LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Deb
 
Posts: n/a
Default sorting scores

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



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
golf handicap 4 of last 5 scores Golf.nut1 Excel Discussion (Misc queries) 15 April 3rd 08 06:11 AM
sorting golf scores Tommy Excel Discussion (Misc queries) 5 April 6th 06 07:00 AM
Calculating average scores from multiple sheets' information quailhunter Excel Worksheet Functions 2 October 16th 05 10:37 PM
Football Scores Number_8 Excel Discussion (Misc queries) 4 August 12th 05 05:46 PM
Golf Handicap Using Last 5 Scores Golf League Schedule Excel Worksheet Functions 5 May 13th 05 12:14 AM


All times are GMT +1. The time now is 02:21 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"