pak anton selalu cermat dlm memilih fungsi dan penggunaannya...

terima kasih pak, 



----- Original Message ----- 
From: anton suryadi 
To: [email protected] 
Sent: Friday, November 06, 2009 04:20PM
Subject: Re: [belajar-excel] Mencari Max Banyaknya Cell Kosong yg bergandengan

Array Formula:
=MAX(FREQUENCY(IF(H5:H24="",ROW(H5:H24)),IF(H5:H24<>"",ROW(H5:H24))))

>semoga bener 

Kirim email ke