Posted to microsoft.public.excel.worksheet.functions

external usenet poster

Posts: 18

Ranking from one sheet to another

I'm trying to rank a particular result from one sheet to a range of results
from another sheet but it is giving me an error when I do so. Here is the
formula I'm using...

=RANK(AD16,National!B16:B56,0)

I'm not sure what would be wrong with that, unless I have to factor in
another formula to indicate the range is on another sheet?

Any help is appreciated. I'm using excell 2007

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to 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 in a Different Way	Smooth813	Excel Discussion (Misc queries)	13	April 10th 10 08:31 PM
Ranking	Excelicious	Excel Worksheet Functions	4	April 3rd 08 06:58 PM
Ranking	dellbad	Excel Worksheet Functions	2	September 11th 07 01:35 AM
Top 10 Ranking again	louiscourtney	Excel Discussion (Misc queries)	0	July 19th 07 04:36 PM
Ranking Question Listing Same Sheet!	Killer	Excel Discussion (Misc queries)	3	June 7th 07 02:12 AM

All times are GMT +1. The time now is 07:13 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us