Excel Formula to looking group of interval data , here is the formula
=IF(AND(IF(ISNUMBER(A1)=FALSE,0,A1)<=80,A2>80),-1,0) Total minutes Status with formula Group 85 -1 ==> 1 30 0 89 -1 ==> 2 89 0 80 0 30 0 89 -1 ==> 3 89 0 30 0 60 0 89 -1 ==> 4 99 0 89 0 86 0 80 0 60 0 89 -1 ==> 5 81 0 60 0 89 -1 ==> 6 81 0 There are six (6) group of data interval which has value > 80
I'm creating Excel VBA function too to looking group interval data=IF(AND(IF(ISNUMBER(A1)=FALSE,0,A1)<=80,A2>80),-1,0) Total minutes Status with formula Group 85 -1 ==> 1 30 0 89 -1 ==> 2 89 0 80 0 30 0 89 -1 ==> 3 89 0 30 0 60 0 89 -1 ==> 4 99 0 89 0 86 0 80 0 60 0 89 -1 ==> 5 81 0 60 0 89 -1 ==> 6 81 0 There are six (6) group of data interval which has value > 80
Call/ Whatsapp 081.223344.506
pinBB 7DC633AA
Freelance Inhouse trainer for Excel VBA Macro, PowerPivot, PowerView
Comments
Post a Comment
Silahkan isi komentar atau iklan baris Anda, Jangan lupa visit social media kami di FB/Twitter/Instagram @alamatclick