Skip to main content

Excel - Looking Group Interval or data group frequency based on max. value

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


by Hery Purnama
Call/ Whatsapp 081.223344.506
pinBB 7DC633AA
Freelance Inhouse trainer for Excel VBA Macro, PowerPivot, PowerView

Comments

Popular posts from this blog

Sewa Ruang Meeting Daerah Citarum Bandung

Sewa ruang meeting kantor, training di Bandung Hubungi 0816-4038-78. Lokasi Ruang Meeting berada di Jl.Pelajar Pejuang 45 No.23B 1. Paket per Jam      - Biaya : Rp.50.000 / org / jam     - Fasilitas : Snack & Drink 2. Paket Half-Day     - Waktu : 09.00 s/d 13.00 Wib     - Biaya : Rp.120.000 / org      - Fasilitas : Makan siang 1x, Snack & Drink 3. Paket Full Day     - Waktu : 09.00 s/d 16.00 Wib     - Biaya : Rp.170.000 / org      - Fasilitas : Makan siang 1x, Coffe break 2x, Snack & Drink 4. Lain-lain     - Sewa Proyektor : Rp.150.000/day     - Extra time : Rp.100.000/Jam Syarat dan Ketentuan : 1. Min. 3org dan Max. 7org 2. Pembayaran H-3 sebelum tgl pelaksanaan 3. Melebihi jam ketentuan dikenakan biaya tambahan Sewa Ruang Meeting Daerah Citarum Bandung Hubungi 0816-4038-78 Ruang meeting murah mulai 50.000 di Buah Batu, Pasteur, Sukajadi, Lengkong, Antapani, Uj...

TRAINING PROJECT MANAGEMENT WITH PRIMAVERA P6-BANDUNG

TRAINING PROJECT MANAGEMENT WITH PRIMAVERA P6 By Purnama Academy - Training Center January 11, 2018  No comments PROJECT MANAGEMENT WITH PRIMAVERA P6 Syllabus Overview PRIMAVERA P6 adalah project management tool yang sangat populer digunakan hampir di perusahan perusahaan skala internasional dan multinasional yang sedang menjalankan project skala besar, lisensi atas PRIMAVERA P6 kini dimiliki oleh Vendor Oracle dan database yang disupport Primavera adalah SQL Server dan Oracle database. Sebagai sebuah software Project Tool skala enterprise maka Primavera memiliki 2 module di dalamnya yaitu (Methodology dan Project Management) Class Type : Training Duration : 4 Days (09.00 – 17.00) Venue  & Price : Click Here , Registration : Click Here  (Save up to 20% for Early Bird Registration !) Detail Syllabus or request for inhouse training  please contact Purnama Academy sales team info@purnamaacademy.com , Hotline (Call/SMS/Whatsapp) : 0838-0838-0001 Speaker  : Purn...