Posted to microsoft.public.excel.worksheet.functions

Shane Devenshire[_2_] Shane Devenshire[_2_] is offline

external usenet poster

Posts: 3,346

Range sort with numerical ranking

Try

=RANK(A1,$A1:$G1)

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire

"Steve" wrote:

If I have these #'s in these days....

1 Sat Sun Mon Tue Wed Thu Fri
2 29 138 18 177 139 150 169

3 6 5 7 1 4 3 2

How can I give the Max #1, the Min # 7, and the proper rankings/places in
between ? ( row 3)

Thanks,

Steve

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
ALPHA/NUMERICAL SORT	MoKaLasco	Excel Discussion (Misc queries)	5	July 4th 09 12:51 PM
display the numerical ranking of a row of numbers in another row	rustydan	Excel Discussion (Misc queries)	1	February 16th 07 12:58 AM
VLOOKUP with numerical sort	JG	Excel Worksheet Functions	3	December 11th 06 02:16 PM
numerical data sort	brichwine	Excel Worksheet Functions	5	February 10th 06 06:32 PM
Another sort of ranking...	Ciprian Baciu	Excel Discussion (Misc queries)	4	July 14th 05 09:27 AM

All times are GMT +1. The time now is 04:40 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us