selecting records
in [General]
|
From: Roy Gudgeon on 8 Mar 2010 07:04 Hi I have a database with over 200 records containing several names with various times taken recorded against each record. I want to be able to sort, then select the best perfroming (fastest) and compile into a report (by name) preferably via Macro. I can do this manually but it will need doing on a month to month basis so want to automate, how canI get excel to select the fastest times from a range and report in another worksheet -- thanks Roy
From: Mike H on 8 Mar 2010 07:15 Hi, You don't give enough detail but if you want the n smallest(fastest) times from a ranges of times then assuming the data are in A1 - A20 put this in a cell and drag down. It will return the fastes then the second fastest etc. =SMALL($A$1:$A$20,ROW(A1)) -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "Roy Gudgeon" wrote: > Hi > > I have a database with over 200 records containing several names with > various times taken recorded against each record. > I want to be able to sort, then select the best perfroming (fastest) and > compile into a report (by name) preferably via Macro. > > I can do this manually but it will need doing on a month to month basis so > want to automate, how canI get excel to select the fastest times from a range > and report in another worksheet > -- > thanks > Roy
From: Roy Gudgeon on 9 Mar 2010 05:30 Hi Mike thanks for reply, sorry for confusion I 'll try to explain more what I need. I have a database of swimmers times. this contains various names, various strokes over various distances, each with a recorded time. I would like to select by swimmers the best times swum for each distance and each stroke. This would create a personal best times file. I can do this manually by filtering and then copying and pasting the individual records. However it is a long job. Each swimmer has 4 strokes (minimum some have 5) over maybe 4 different distances. In my database I have 70+ swimmers ! I know a macro would speed this up but do not know how to select the best times for copying & pasting for each swimmer/stroke after i have filtered/sorted the database. I know Access is probably a better option but, pardon the pun, do not have access to a copy. Can this be done in Excel ? Does my expanation make sense ? thanks Roy -- thanks Roy "Mike H" wrote: > Hi, > > You don't give enough detail but if you want the n smallest(fastest) times > from a ranges of times then assuming the data are in A1 - A20 put this in a > cell and drag down. It will return the fastes then the second fastest etc. > > =SMALL($A$1:$A$20,ROW(A1)) > -- > Mike > > When competing hypotheses are otherwise equal, adopt the hypothesis that > introduces the fewest assumptions while still sufficiently answering the > question. > > > "Roy Gudgeon" wrote: > > > Hi > > > > I have a database with over 200 records containing several names with > > various times taken recorded against each record. > > I want to be able to sort, then select the best perfroming (fastest) and > > compile into a report (by name) preferably via Macro. > > > > I can do this manually but it will need doing on a month to month basis so > > want to automate, how canI get excel to select the fastest times from a range > > and report in another worksheet > > -- > > thanks > > Roy
|
Pages: 1 Prev: can you move icons on the quick access toolbar Next: Can i get the Email |