Home |
Search |
Today's Posts |
#6
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Fortunately for me I need a running start and a tall cliff to get my truck up
to the speed limit. I sometimes miss those carefree days of stomping on the gas pedal, leaving some tread, and blowing off some doors. Now I'm afraid of all the punks who drive like I used to ;-) --mark "T. Valko" wrote: <humor You'll regret this the day you get caught in a speed trap now that you've told them the best time is to catch you! <VBG </humor -- Biff Microsoft Excel MVP "Dave O" wrote in message ... Hi, Mark- I wasn't sure how you wanted to include the peak and low speeds- if you can post some sample data it would be easier to figure out. I'm leaving for the day very shortly but if you get bogged down in applying the peak and low speeds send me an email at cyclezen ATSIGN yahoo daht calm. I check email there more frequently than I check posts here. SUMPRODUCT with the double unary operator is a powerful tool to keep in your Excel arsenal- I learned about it at this usenet group: http://groups.google.com/group/micro...?hl=en&lnk=srg It amounts to a SUMIF, but allows you to many "ifs" instead of just one- cool stuff. Have a good weekend! Dave O Eschew obfuscation |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Max value for each day, and hour of that occurrence | Excel Discussion (Misc queries) | |||
Counting occurrences in one column based on an occurrence in anoth | Excel Worksheet Functions | |||
Counting the number of cells within a certain hour. | Excel Discussion (Misc queries) | |||
Calculating a colmun to total a 40 hour work week | Excel Worksheet Functions | |||
Counting Occurrence of Text within Text in Cells in Range. | Excel Worksheet Functions |