l Enter.
>
> maka formulanya akan ada tambahan kurung kurawal {}
>
>
>
> Oia, jika indexnya dirubah menjadi $D$2:$D$1026, maka pada row juga
> demikian row($C$2:$C$1026)
>
>
>
>
>
> Wassalam
>
> ~ Bagus ~
>
> - Original Message -
>
> *From
!!!
ISO 9001 : 2008| ISO 14001 : 2004 | OHSAS 18001 : 2007
From: belajar-excel@yahoogroups.com [mailto:belajar-excel@yahoogroups.com]
Sent: Thursday, October 16, 2014 4:21 PM
To: belajar-excel@yahoogroups.com
Subject: Re: [belajar-excel] menginput data secara otomatis dengan satu key
Pak Sam
: Thursday, October 16, 2014 2:25 PM
Subject: RE: [belajar-excel] menginput data secara otomatis dengan satu key
[1 Attachment]
Dear Master Excel,
Pada kolom 2 rumus aslinya :
=IFERROR(INDEX(D$2:D$112,SMALL(IF($M$1=$C$2:$C$112,ROW($C$2:$C$112)-ROW($C$1)),ROW(1:1))),"")
diub
:46 AM
To: belajar-excel@yahoogroups.com
Subject: Re: [belajar-excel] menginput data secara otomatis dengan satu key [1
Attachment]
Wa'alaykum salam warohmatullohi wabarokatuhu
Pak Samsudin;
Sila lihat file terlampir
semoga sesuai harapan
Wassalam
~ Bagus ~
- Original Messa
Wa'alaykum salam warohmatullohi wabarokatuhu
Pak Samsudin;
Sila lihat file terlampir
semoga sesuai harapan
Wassalam
~ Bagus ~
- Original Message -
From: Samsudin samsu...@bayan.com.sg [belajar-excel]
To: belajar-excel@yahoogroups.com
Sent: Thursday, October 16, 2014 9:14
5 matches
Mail list logo
