LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 5
Default Ranking Values that Meet a Certain Criteria

How can I rank a set of values in a range that meet a specified
criteria?

An example:
range A1:A10 contains the number of wins a team has. range B1:B10
contains each team's goal differential. For teams that have the same
number of wins, I want to be able to rank them on their goal
differential. I don't want to sort the list and then rank (this is a
simplified example) - rather having excel automatically identifying
all of the ties and breaking them.

Any help??

Thanks,
adh

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
add numbers if they meet criteria...? Dan B Excel Worksheet Functions 2 January 31st 07 11:47 PM
how to sum highest ranking values meeting criteria within a limit? QuantumPion Excel Discussion (Misc queries) 4 June 7th 05 02:15 PM
Sum range of values that meet date criteria Ed Wurster Excel Discussion (Misc queries) 2 April 11th 05 08:06 PM
Counting Values that meet another cells criteria Jess Excel Worksheet Functions 1 March 8th 05 01:42 AM
Sum the values of one column, only if they meet certain criteria . Todd Pippin Excel Worksheet Functions 0 February 8th 05 04:37 PM


All times are GMT +1. The time now is 08:27 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"