John

Posts: n/a

Rank

I Have a list of about 50 differnt numbers. The numbers are constantly
changing. I need to figure out who many points behind the highest score is
each individual cell.

Example:

a1=50
a2=45
a3=33
a4=59

So in column B i want to say that a1 is 9 points behind the leader. A2
would be 14 points behind the leader.

Any idea's?

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
Can I assign a rank based on a cells' value	Jason	Excel Worksheet Functions	1	March 10th 05 09:54 PM
Rank fx - Fill Down?	Steve B	Excel Worksheet Functions	1	February 23rd 05 08:28 PM
Rank in Excel	koty	Excel Worksheet Functions	3	February 8th 05 08:04 PM
Rank() based on category	Henrik	Excel Worksheet Functions	1	January 12th 05 08:40 PM
Rank Function	carl	Excel Worksheet Functions	2	November 15th 04 07:23 PM

All times are GMT +1. The time now is 10:25 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us