[milis-belajar-excel] Hanya menghitung sampai kolom minus pertama

classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

[milis-belajar-excel] Hanya menghitung sampai kolom minus pertama

Matzen, M. (Matzen)

Dear master,

 

Dah coba sana-sini, belom ketemu nih,

Saya mencoba menghtung nilai 1, dan akan berhenti di angka minus dan seterusnya, walaupun angka seterusnya jadi plus, akan tetap jadi nol

 

                  -  

                  -  

                  -  

                  -  

 

           10,000

              1,734

                610

               (514)

             (1,638)

             (2,763)

              7,237

                  -  

                  -  

                  -  

                  -  

                  -  

                  -  

                    1

                    1

                  -  

                  -  

                  -  

                    1

 

 

Best Regards

 

 

Matzen

 

--
You received this message because you are subscribed to the Google Groups "milis Belajar-Excel" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email].
To view this discussion on the web visit https://groups.google.com/d/msgid/milis-belajar-excel/AM8PR06MB7026B4E5C48BEB0CD2E0942A85689%40AM8PR06MB7026.eurprd06.prod.outlook.com.
Kid
Reply | Threaded
Open this post in threaded view
|

Re: [milis-belajar-excel] Hanya menghitung sampai kolom minus pertama

Kid
Administrator
Hai Matzen,

Apakah maksudnya akan menghitung banyaknya cells sebelum ditemukannya minus pertama kali ?

1,734

                610

               (514)

             (1,638)

             (2,763)

              7,237

Untuk data tersebut, banyaknya cells sebelum ditemukannya minus pertama kali adalah 2
Misal data di beris Excel 2, dan cells pertama (yang bernilai 1,734) ada di kolom D, artinya ada 3 kolom Excel yang diabaikan.
=LookUp( 0 , -D2:i2 , Column( D2:i2 ) - 3 )
*** catatan : angka nol itu bukan minus ya...








On Fri, Mar 19, 2021 at 5:52 PM 'Matzen, M. (Matzen)' via milis Belajar-Excel <[hidden email]> wrote:

Dear master,

 

Dah coba sana-sini, belom ketemu nih,

Saya mencoba menghtung nilai 1, dan akan berhenti di angka minus dan seterusnya, walaupun angka seterusnya jadi plus, akan tetap jadi nol

 

                  -  

                  -  

                  -  

                  -  

 

           10,000

              1,734

                610

               (514)

             (1,638)

             (2,763)

              7,237

                  -  

                  -  

                  -  

                  -  

                  -  

                  -  

                    1

                    1

                  -  

                  -  

                  -  

                    1

 

 

Best Regards

 

 

Matzen

 

--
You received this message because you are subscribed to the Google Groups "milis Belajar-Excel" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email].
To view this discussion on the web visit https://groups.google.com/d/msgid/milis-belajar-excel/AM8PR06MB7026B4E5C48BEB0CD2E0942A85689%40AM8PR06MB7026.eurprd06.prod.outlook.com.

--
You received this message because you are subscribed to the Google Groups "milis Belajar-Excel" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email].
To view this discussion on the web visit https://groups.google.com/d/msgid/milis-belajar-excel/CAOiZkPuZbnhtjf%2B_kNKGwrdpVZjTceyiafdpqPhsTXXqEZ6EmQ%40mail.gmail.com.
Reply | Threaded
Open this post in threaded view
|

RE: [milis-belajar-excel] Hanya menghitung sampai kolom minus pertama

Matzen, M. (Matzen)

Hi Mr.Kid

 

Jika A2 sampai E2 bernilai plus maka bernilai 1 dan jika kolom selanjutnya (row 1) baik bernilai minus atau pun bernilai plus akan tetap di anggap 0

 

 

 

From: [hidden email] <[hidden email]> On Behalf Of Mr. Kid
Sent: 19 March 2021 8:34 PM
To: milis Belajar-Excel <[hidden email]>
Subject: Re: [milis-belajar-excel] Hanya menghitung sampai kolom minus pertama

 

Hai Matzen,

 

Apakah maksudnya akan menghitung banyaknya cells sebelum ditemukannya minus pertama kali ?

1,734

                610

               (514)

             (1,638)

             (2,763)

              7,237

Untuk data tersebut, banyaknya cells sebelum ditemukannya minus pertama kali adalah 2

Misal data di beris Excel 2, dan cells pertama (yang bernilai 1,734) ada di kolom D, artinya ada 3 kolom Excel yang diabaikan.

=LookUp( 0 , -D2:i2 , Column( D2:i2 ) - 3 )

*** catatan : angka nol itu bukan minus ya...

 

 

 

 

 

 

 

 

On Fri, Mar 19, 2021 at 5:52 PM 'Matzen, M. (Matzen)' via milis Belajar-Excel <[hidden email]> wrote:

Dear master,

 

Dah coba sana-sini, belom ketemu nih,

Saya mencoba menghtung nilai 1, dan akan berhenti di angka minus dan seterusnya, walaupun angka seterusnya jadi plus, akan tetap jadi nol

 

                  -  

                  -  

                  -  

                  -  

 

           10,000

              1,734

                610

               (514)

             (1,638)

             (2,763)

              7,237

                  -  

                  -  

                  -  

                  -  

                  -  

                  -  

                    1

                    1

                  -  

                  -  

                  -  

                    1

 

 

Best Regards

 

 

Matzen

 

--
You received this message because you are subscribed to the Google Groups "milis Belajar-Excel" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email].
To view this discussion on the web visit https://groups.google.com/d/msgid/milis-belajar-excel/AM8PR06MB7026B4E5C48BEB0CD2E0942A85689%40AM8PR06MB7026.eurprd06.prod.outlook.com.

--
You received this message because you are subscribed to the Google Groups "milis Belajar-Excel" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email].
To view this discussion on the web visit https://groups.google.com/d/msgid/milis-belajar-excel/CAOiZkPuZbnhtjf%2B_kNKGwrdpVZjTceyiafdpqPhsTXXqEZ6EmQ%40mail.gmail.com.

--
You received this message because you are subscribed to the Google Groups "milis Belajar-Excel" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email].
To view this discussion on the web visit https://groups.google.com/d/msgid/milis-belajar-excel/AM8PR06MB70260B95CB21337BEF024C4285689%40AM8PR06MB7026.eurprd06.prod.outlook.com.