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 |
sorting multiple minimum times
I'm willing to take the challenge but unfortunatley I'm a visual kinda guy.
If you feel comfortable sending me the spreadsheet I'd be willing to take a look. I used to swim in High School. 100m Butterfly. So I understand what you're trying to get at. Send the file and I'll do what I can. -Jacob F. Roecker "the swimmer" wrote: 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 |
All times are GMT +1. The time now is 01:03 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com