Posted to microsoft.public.excel.worksheet.functions

jbg

external usenet poster

Posts: 16

ranking?

In my workbook I have a set of numbers that I want to rank. I have a empty
colomn and when I use the rank function it displays the error window. I know
I am making this harder than needed. What do I use in the number, ref,
order? The numbers I want to rank numbers E4:E34 and have column F empty.

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
Ranking	Will	Excel Discussion (Misc queries)	10	April 11th 07 11:04 AM
Ranking	casdaq	Excel Worksheet Functions	0	March 28th 07 12:09 AM
ranking	Blade370	Excel Worksheet Functions	6	February 8th 07 10:53 AM
Ranking	linzi00	Excel Discussion (Misc queries)	2	October 5th 06 05:42 PM
Ranking	Tim Sullivan	Excel Worksheet Functions	7	July 18th 05 07:00 PM

All times are GMT +1. The time now is 09:28 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us