Fantastis formula Mr. Kid.
Salam,HK
----- Forwarded message ----- From: 'Mr. Kid' [email protected]
[belajar-excel] <[email protected]>To: BeExcel
<[email protected]>Sent: Wednesday, 29 August 2018, 8:47:40 PM
GMT+7Subject: Re: [belajar-excel] Rumus Jumlah berdasarkan waktu
Begini
:=$F4*(COLUMN(A1)=MATCH($G$1-$G4,{0,31,61,92,121,151,181,210,241,271,301,331,361}))
Regards,Kid
On Wed, Aug 29, 2018 at 6:50 PM halak hita [email protected]
[belajar-excel] <[email protected]> wrote:
Dear para MasterMohon dibantu dalam lampiran berikut.apa rumus tepat dan yang
mudah dipahami agar data (yang diberi warna kdapat menyesuaikan otomatis
seiring berjalannya waktu
salamHH
