Jeff

Posts: n/a

Rank Function

I have a number in cell A1, and two lists of numbers in cells D11:D21 and
E33:E43

I want to find the rank of cell A1 out of the cells in D11:D21 and E33:E43.

But the rank function seems to require that the value in cell A1 be part of
the range D11:D21 or E33:E43. It does not seem to allow me to take the rank
when the cell values are seperated.

Is there any way around this?

Thanks

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
Changing worksheet cells from within a function	James4U2enjoy	Setting up and Configuration of Excel	1	October 14th 05 02:16 PM
Automatically up date time in a cell	Mark	Excel Discussion (Misc queries)	5	May 12th 05 12:26 AM
SUMIF function	yak10	Excel Worksheet Functions	0	February 12th 05 05:12 PM
HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE.	Robert AS	Excel Worksheet Functions	4	December 2nd 04 10:49 AM
Find a Function to use accross different worksheets	R. Hale	Excel Worksheet Functions	3	November 25th 04 07:07 AM

All times are GMT +1. The time now is 09:58 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us