Posted to microsoft.public.excel.misc

Will

external usenet poster

Posts: 129

Ranking search

Dear All,

I wan a formula to "detect" who have the highest mark amount the whole
score table.

Test 1 Test 2
Jo 56 55
Mark 98 06
Simon 89 57
Stella 88 58
Jean 50 51

I wan a Formula to show:

Highest sco Mark, Test 1
Lowest sco Mark, Test 2

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?	Saxman	Excel Discussion (Misc queries)	3	October 4th 06 04:32 PM
Ranking	Curtis	Excel Worksheet Functions	5	May 14th 06 03:59 AM
How do I search excel spreadsheets using multiple search criteria.	Kasper	Excel Worksheet Functions	4	December 15th 05 12:26 AM
ranking	tagraeff	Excel Worksheet Functions	4	October 26th 05 11:59 AM
Ranking	Tim Sullivan	Excel Worksheet Functions	7	July 18th 05 07:00 PM

All times are GMT +1. The time now is 06:19 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us