Question about Microsoft Excel for PC

1 Answer

Microsoft Excel Formula

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?

Posted by on

1 Answer

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    MVP:

    An expert that gotĀ 5 achievements.

    Governor:

    An expert whose answer gotĀ voted for 20 times.

    Scholar:

    An expert who has written 20 answers of more than 400 characters.

  • Expert
  • 104 Answers

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.
Regards
SeaJade

Posted on Mar 07, 2008

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

2 Answers

IS THERE A FORMULA IN EXCEL THAT WILL HIGHLIGHT CELLS THAT MATCH A NUMERICAL INVENTORY LIST?


One way would be to create a colunn C and use the formula: =COUNTIF(B$2:B$200,A2) in cell C2. Then copy the formula down to C200. (assuming you have 200 entries in B...). This will put a "1" next to every number in Column A that has a match in column B. Then you could put a conditional formula in column A that will highlight the cell if the value in column C is equal to 1. Alternatively you could also simply filter for 1's in column C and then manually highlight the cells that show up in A!

Sep 16, 2014 | Microsoft Excel for PC

1 Answer

Trying to figure the formula below based on 9 hour work weeks and 24 hr weekends


Please be more clear with the question.. Do you want me to analyze the formula?

Feb 21, 2008 | Microsoft Excel for PC

2 Answers

What are the formulas in grading the grades uisng microsoft excel


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.

  1. All formulas begin with an equals sign (=).
  2. Some formulas use operands such as +,-, *,/ for addition, subtraction, multiplication or division.
    For example, the formula =A1+A2+A3 would add the contents of cells A1, A2 and A3.
  3. Other formulas refer to different functions such as SUM, AVERAGE and others.
    For example, the formula =SUM(A1:A3) would add the contents for the range A1 through A3.
  4. Formulas can be combined with operands.
    For example, the formula =10*SUM(A1:A3) would add the contents cells A1 through A3 and multiply them by 10.
  5. Functions can be nested within each other.
    For example, the formula =SQRT(10*SUM(A1:A3)) would take the square root of ten times the sum of cells A1 through A3. When functions are nested, it is important that the number of left parentheses match the number of right parentheses.

Aug 19, 2011 | Microsoft EXCEL 2004 for Mac

2 Answers

What is the function of Microsoft excel?


Ok - if your question is "What is Excel" - then the answer is that it is a spreadsheet program that allows you the ability to compute data (usually numbers) for example, pulling together a list of hours worked by employees and adding them up automatically. It also can be used to develop sophisticated computational models and I have used it to develop professional services proposal sizing tools using formulas and functions ... which is a good segwey into my other answer.

If your question is "what is a function or formula in Excel" - then the answer is a function or formula in Excel is a collection of mathematical, text, statistical, etc. preprogrammed tools that allows you to manipulate the data you have in your spreadsheet e.g. a SUM() function that adds a series of numbers, and AVERAGE() funtion that computes the average of a series of numbers, etc.

Hope that helps!

Rgds

David

Oct 01, 2010 | Microsoft Office Excel 2007 Upgrade:...

1 Answer

Excel radom selection formula not working


What are the values of cells C4 and C5? Should the function above be "...RANDBETWEEN(A$4,A$5)" ?

Jun 29, 2009 | Microsoft Office Excel 2003 for PC

4 Answers

I want the excel compound interest formula


=10000*(1+0.96)^12
=10000*(1+0.10)^18
=10000*(1+0.10)^24

Dec 02, 2008 | Microsoft Office Professional 2007 Full...

2 Answers

Formula for calculating the days beween months


for example, cell A1 has date (01-01-2008) and cell A2 has current date (08-24-2008) and cell A3 shows total days, is that you want to know? if yes, apply formula as under...

cell A3......(properties set as General to show digits)................ =SUM(A2-A1)

Aug 25, 2008 | Microsoft Office Professional 2007:...

2 Answers

EXCEL ALL SHORT FORMULA


hiiiiiii
u know vlookup function,then piviot table
u know na tell short formula
genious...

Dec 14, 2007 | Microsoft Excel for PC

1 Answer

Ms excel fomulas


dear monalinda you have to enter formula in formula bar with = sign and select the coloumn & rows

Sep 24, 2007 | Microsoft Office Standard for PC

1 Answer

Excel formula


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

Not finding what you are looking for?
Microsoft Excel for PC Logo

101 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Business & Productivity Software Experts

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18297 Answers

Sudeep Chatterjee
Sudeep Chatterjee

Level 3 Expert

3267 Answers

Are you a Microsoft Business and Productivity Software Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...