sorting multiple rows

C

CCOD

I am trying to sort a spreadsheet for a golf scoring system. Each team has
four players (each in their own row) that have their own handicaps. Then a
team handicap is generated (in a separate column) from a formula using the
individuals scores. I then want to sort by the teams by their team handicap
but keep all four players rows with that team handicap. Is there a way to
sort like this?
 
B

bpeltzer

Do you have a column showing the team name? If so, you can do this easily.
Select your entire table and then, from the menu bar: Data > Sort... Select
TeamName in the first drop-down and IndividualHandicap in the second
drop-down (I've assume you have columns with those headers in the first row;
adjust the lables based on your table's particulars).
(If you don't have a column for the team name, you could try sorting on the
team handicap in the first drop-down, but if you have two teams with the same
handicap, their players will get intermingled).
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top