Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
tough question--determine smallest time from range with exceptions
I am trying to create a macro to determine the smallest time in selected
recurring ranges but with the exceptions that the distance was < max dist. and than min. dist. and then copy all corresponding data from the fastlap into another sheet. Please help....I've been trying for 2 days now. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
tough question--determine smallest time from range with exceptions
To clarify: The times are in C2 and the distances are in C10 with the max in
R1C7 and min in R1C8. The data that has to be copied is all data in the same row as the minimum time. eg. RxC2:RxC9. There is a set of data that it must sort and then a blank line, then start the loop over again for the next fast time. Thank you for any help you can provide. "xadnora" wrote: I am trying to create a macro to determine the smallest time in selected recurring ranges but with the exceptions that the distance was < max dist. and than min. dist. and then copy all corresponding data from the fastlap into another sheet. Please help....I've been trying for 2 days now. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
tough question--determine smallest time from range with except
You have completely lost me. Can you post an example of what it is you are
trying to accomplish. "xadnora" wrote: To clarify: The times are in C2 and the distances are in C10 with the max in R1C7 and min in R1C8. The data that has to be copied is all data in the same row as the minimum time. eg. RxC2:RxC9. There is a set of data that it must sort and then a blank line, then start the loop over again for the next fast time. Thank you for any help you can provide. "xadnora" wrote: I am trying to create a macro to determine the smallest time in selected recurring ranges but with the exceptions that the distance was < max dist. and than min. dist. and then copy all corresponding data from the fastlap into another sheet. Please help....I've been trying for 2 days now. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
tough question--determine smallest time from range with except
I will post a link to the file.....i can't attach it to the post through the
microsoft site....i need to get my newsreader info from my house. www.ncat.edu/~dax "Jim Thomlinson" wrote: You have completely lost me. Can you post an example of what it is you are trying to accomplish. "xadnora" wrote: To clarify: The times are in C2 and the distances are in C10 with the max in R1C7 and min in R1C8. The data that has to be copied is all data in the same row as the minimum time. eg. RxC2:RxC9. There is a set of data that it must sort and then a blank line, then start the loop over again for the next fast time. Thank you for any help you can provide. "xadnora" wrote: I am trying to create a macro to determine the smallest time in selected recurring ranges but with the exceptions that the distance was < max dist. and than min. dist. and then copy all corresponding data from the fastlap into another sheet. Please help....I've been trying for 2 days now. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Tough Question | Excel Worksheet Functions | |||
Any function to determine the smallest common factor from a list? | Excel Discussion (Misc queries) | |||
formula to determine time range overlap? | Excel Discussion (Misc queries) | |||
Tough question | Excel Discussion (Misc queries) | |||
how to determine blocks of time in a date range | Excel Discussion (Misc queries) |