The script I’m using takes 6 months into account. Then calculates the Standard Deviation.
I’m hoping someone can help me fix the code below to skip fields that have “false” or a “zero”
VBA Script I’m using:
Expand|Select|Wrap|Line Numbers
- Public Function GetXLStDev(No1 As Double, No2 As Double, No3 As Double, No4 As Double, No5 As Double, No6 As Double) As Double
- Dim objExcel As Object
- Set objExcel = CreateObject("Excel.Application")
- Let GetXLStDev = objExcel.StDev(No1, No2, No3, No4, No5, No6)
- objExcel.Quit
- Set objExcel = Nothing
- End Function
- Public Function Pause(PauseSeconds As Double)
- Dim Start
- Start = Timer
- Do While Timer < Start + PauseSeconds
- DoEvents
- Loop
- End Function
TCB