| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Writing a VBA program
I am trying to write a script to help me determine the Mean Time Between
Repair for equipment. I played with it all day yesterday but was not able to figure it out. Right now I have to enter the string manually. The formula I am using is "=AVERAGE(C7-C6,C6-C5,C5-C4,C4-C3,C3-C2)" where C7 would be the latest date to C2 the earliest date. As you can see this would become cumbersome with numerous dates. Thanks, -- Jim |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is there a way to unload the loaded XLL file in Excel? Hi all, I amdebugging XLL link library using Visual C++. Everytime I rebuild the XLL, Ihave to close the whole Excel program and relaunch the Excel program again,and then load in the newly gene | Excel Discussion (Misc queries) | |||
| writing a text file in the same folder as my program | Excel Programming | |||
| Writing a program to archive information | Excel Programming | |||
| Re writing program - 3/4 rogrammers input on this spreadsheet, ! | Excel Programming | |||
| merging excel program with tdc finance program | Excel Programming | |||
Threaded Mode
