Legue tables in excel

Microsoft Office excel 2007
August 22, 2010 at 05:35:28
Specs: Windows 7
I HAVE CREATED A LEGUE TABLE WHERE IT COLATES FIGURES FROM OTHER DATA, THE LEGUE IS FOR FOOTBALL TEAMS AND POINTS TOTALS. BUT WHEN I TRY TO SORT IN TO TEAM WITH THE MOST POINTS TO LEAST POINTS, IT CHANGES THE FIGURES IN ONE COLUMN AND JUGGLES THE TEAMS ABOT IN THE OTHER COLUMN.
I WOULD LIKE TO AUTOMATICALLY AJUST THE TABLE EACH WEEK AS I ADD NEW FIGURES IS THIS POSSIBLE

See More: Legue tables in excel

Report •


#1
August 22, 2010 at 05:59:41
Hi,

A few points:
1. Posting in caps/upper case is considered to be shouting - which you probably/hopefully did not mean to do.

2. To get help you need to provide sufficient detail to enable someone who hasn't seen your data, to propose a solution.

You need to tell us where your data is, for example - I have team names in column A, with a heading in cell A1 and the names in A2 to A20

3. Saying that something doesn't work is not very useful:
It changes the figures in one column and juggles the teams about in the other column
You need to say what you did and what happened, for example - I selected column A and used Sort (No header & Ascending selected). The names in column A were sorted into alphabetical order, but the data in the rows in column C didn't change and now does not match up with the names on the same rows.

4. If you have formulas, a sample of each formula would help, for example - Column D has a header in cell D1 then formulas on the remaining rows, cell D2 contains =C2/E2

5. Sometimes posting a small sample of your data helps. To do this put your data between <pre> and </pre> tags that you can insert using the 'Pre' icon above the reply box. Then use the Preview button and edit, as required. To preview again, check the 'Check To Show Confirmation Page Again' box and click 'Confirm and see post'

Regards


Report •
Related Solutions


Ask Question