| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
sorting multiple minimum times
Hi all I've created a database with times recorded for individuals in each event, distance etc swum. This gives a list from which I need to get the minimum time swum by each competitor in each event taking say the best ten times overall in each group. Its easy to sort out the best 10 times using a function like 'small' but I need to filter sorting out best 10 times in each group by competitor event, age of competitor and possibly other criteria (like male/female etc) At present I'm stumped any help would be appreciated. I've seen some bespoke add ins available from people like dbdig but feel sure it can be done by advanced filtering and formulas. Any help appreciated. -- the swimmer ------------------------------------------------------------------------ the swimmer's Profile: http://www.excelforum.com/member.php...o&userid=29863 View this thread: http://www.excelforum.com/showthread...hreadid=495665 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VLOOKUP loop multiple times | Excel Worksheet Functions | |||
| Advice sought: Multiple column sorting | Excel Worksheet Functions | |||
| Count # of times value "x" appear across multiple worksheets | Excel Worksheet Functions | |||
| How do I print the same sheet multiple times with increasing page. | Excel Discussion (Misc queries) | |||
| How to find the minimum value in a database with multiple values . | Excel Discussion (Misc queries) | |||
Threaded Mode
