Excel looking group interval or frequency (formula an VBA Macro)

Excel Formula to looking group of interval data 
=IF(AND(IF(ISNUMBER(A1)=FALSE,0,A1)<=80,A2>80),-1,0)
Total minutes Status dengan formula Group
85 -1 ==> Group 1
30 0
89 -1 ==> Group 2
89 0
80 0
30 0
89 -1 ==> Group 3
89 0
30 0
60 0
89 -1 ==> Group 4
99 0
89 0
86 0
80 0
60 0
89 -1 ==> Group 5
81 0
60 0
89 -1 ==> Group 6
81 0
There are six (6) group of data interval which has value > 80

I’m creating vba function as well to looking the Group Frequency in Excel

Function cariinterval(sel1 As String, sel2 As Single) As Single

Dim vsel1 As Single

If IsNumeric(sel1) = False Then
    vsel1 = 0
    Else
    vsel1 = sel1
End If

If vsel1 <= 80 And sel2 > 80 Then
    cariinterval = -1
    Else
    cariinterval = 0
    End If

End Function

Hery Purnama – 081.223344.506 – inhousetrainer@yahoo.com.
Freelance IT Trainer, Trainer Excel VBA Macro, Trainer Sencha ExtJS, Trainer Google Map API, Trainer SPSS, Trainer MS Project, Trainer Primavera, Trainer Google Sktechup 3D, Trainer Android Phonegap, Trainer Oracle, Trainer SQL Server, Trainer MySQL, Trainer PHP Jquery Mobile , Trainer Java, Trainer HTML5 Javascript, Trainer SEO Internet Marketing, Trainer Project Management, Trainer SMS Gateway, Trainer CMS WordPress, ITIL, COBIT

Author: Inhouse Trainer freelance

Hery Purnama 081.223344.506 - Freelance Trainer , Excel VBA Macro, Android, Phonegap, ITIL, COBIT, Google Map API, Sketchup3D , MS Project, Sencha ExtJS, Oracle , MySQL DBA, MS. Access VBA, Primavera P6, MS Project ,Jquery, Yii, CodeIgniter. laravel, CATIA 3D, Unity 5 , PMBOK, PMO, TOGAF, PRINCE2 - Call : 081.223344.506 | PinBB : 7DC633AA| Email / YM : inhousetrainer@yahoo.com | FB : inhousetrainer | TW : inhousetrainer

Leave a Reply

Your email address will not be published. Required fields are marked *