Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-16-2013, 10:10 AM
TerryStevenson TerryStevenson is offline Scores returning ranked results Windows XP Scores returning ranked results Office 2007
Novice
Scores returning ranked results
 
Join Date: Sep 2013
Posts: 3
TerryStevenson is on a distinguished road
Default Scores returning ranked results


Hi,

I have searched both these forums and google and so far I am just confusing myself.

I have a spreadsheet with teams, all of which have scores for different competitions. Once the total has been tallied i would love to have the groups ranked, i cannot for the life of me think how to do this.. it would purely be a row to the right of total whereby "1st" to "10th" is displayed beside the appropriate team.

Any assistance anyone can offer would be fantastic,

Cheers
Reply With Quote
  #2  
Old 09-16-2013, 12:20 PM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Scores returning ranked results Windows 7 64bit Scores returning ranked results Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,470
Pecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to behold
Default

Perhaps have a look at the RANK function
Reply With Quote
Reply

Tags
ranking, scores

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Scores returning ranked results Drop down list of numbers returning colours michaelvw Excel 1 09-06-2013 09:51 AM
Returning a specific value when item is selected from a drop-down list J Press Excel 4 09-10-2012 06:12 AM
Returning my OPS settings in Office 2010 PMKoning Office 2 12-15-2010 09:54 AM
Keeping scores in ppt, please please help piper7971 PowerPoint 0 07-24-2010 07:10 PM
Returning Next Record to the top bordercollie10 Mail Merge 0 02-26-2009 09:06 AM

Other Forums: Access Forums - Senior Forums

All times are GMT -7. The time now is 10:55 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2021, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2021 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft