database tables

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Database & Tables

Database & Tables

resolvedResolved · Urgent Priority · Version 2003

Database & Tables

I'm running a fantasy football mini league and we are having a monthly manager's prize.
I at midday on the first of each calender month will copy ( ctrl c ) the information from the SUN website ( which we have all signed up to ), this info is team name, team owners name, and points.
Now to decide our winner I need to deduct month one from month two etc, which is easy enough, a subtraction sum, but then I wish all the information in the row to be copied with the revelent points in that row, and then I can sort in decending order etc.

RE: Database & Tables

Hello Stephen

Thank you for your post.

Although this sounds interesting we are only able to provide support and advice relating to the content of the courses you have attended with us, in accordance with the acceptable use policy for the forum.

Kind regards
Amanda


 

Excel tip:

Apply currency format quickly in Excel

To quickly apply the currency format to cell in your spreadsheet, select (highlight) the cells you wish to apply currency format to, then use Ctrl + Shift + $

This will apply a pounds symbol even though the $ key is pressed.

View all Excel hints and tips


Server loaded in 0.09 secs.