Question about Microsoft Excel for PC
Hi I am trying to organise a tipping competiton with 24 people. I have worked out the formula to add the coloumns together so they have a running tally each week. But now I am trying to work out if there is any way of getting the 1st place person for the week to move to the top of the page followed by 2nd place then 3rd place and so on down the page. Can you get them to change automatically each week or will I have to do it manually?
Hi, probably the easiest way would be to create a macro and attach it to a button which would automatically sort the required column in descending order. When Excel does this it reorders the whole list so that the names correspond correctly. To do this you simply go to the tools menu and select macros and "record new macro" then click any cell in the results that make that person coming first etc, then click the sort descending button on the toolbar, then click stop record.
Afterwards create a button from the "toolbox controls" and then view the code for both the button and the macro and copy the macro code and paste it into the "click" option for the button.
If you need an example or anything else give me a yell.
Posted on Mar 07, 2008
Tips for a great answer:
Sep 16, 2014 | Microsoft Excel for PC
Feb 21, 2008 | Microsoft Excel for PC
Formulas are used to specify calculations based on values in designated cells. Excel supports basic calculations as well as statistical, trigonometric and other specialized functions.
Formulas used in Excel must follow a certain syntax.
Aug 19, 2011 | Microsoft EXCEL 2004 for Mac
Oct 01, 2010 | Microsoft Office Excel 2007 Upgrade:...
Jun 29, 2009 | Microsoft Office Excel 2003 for PC
Dec 02, 2008 | Microsoft Office Professional 2007 Full...
Aug 25, 2008 | Microsoft Office Professional 2007:...
Relative cell reference is address of cell , when copied from one cell to another gets changed automatically.
e.g. Put formula in cell c5 as A5+1 when you copy this from c5 to c6 the address of A5 will automatically changed to A6.
Absolute Cell Reference
As above now put formula in cell C5 as $A$5+1 ,now copy this formula from C5 to C6 if you this formula youwill find cell Address of A5 does not changed.
Mixed Cell Reference:
If we put Dollar ($) sign before Alphabetic cell address i.e.$c5 then even if you copy this formula in any cell , coloumn (c) will remains constant.
Similarly if we put Dollar ($) sign before Numeric cell address i.e.c$5 then you copy this formula in any cell row address of the cell remains same.(5).
Pl elobarate on remaining two points 'Specific order of formulas ' and 'advance formulas,
Sep 15, 2007 | Microsoft Office Standard for PC
Jan 28, 2016 | Microsoft Excel for PC
101 people viewed this question
Usually answered in minutes!
Level 3 Expert
Level 3 Expert
Level 3 Expert
Step 2: Please assign your manual to a product: