Posted to microsoft.public.excel.worksheet.functions

external usenet poster

Posts: 64

Ranking if number is 550

I need to know how to rank a list of numbers but only rank the numbers above
550.
Example
A
1523
1242
550
890

I need to rank 1523, 1242, 890, and leave 550 out...
So the ranking should be 1523:3, 1242:2, and 890:1
Thanx.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
Top 10 Ranking again	louiscourtney	Excel Discussion (Misc queries)	0	July 19th 07 04:36 PM
Top 10 Ranking	louiscourtney	Excel Discussion (Misc queries)	10	July 19th 07 03:28 PM
I want to assign a ranking number to a series of values.	tdkdik	Excel Worksheet Functions	1	April 3rd 07 05:26 PM
ranking	Blade370	Excel Worksheet Functions	6	February 8th 07 10:53 AM
Ranking?	Saxman	Excel Discussion (Misc queries)	3	October 4th 06 04:32 PM

All times are GMT +1. The time now is 12:59 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us