[belajar-excel] Digest Number 1414

Milis Belajar Microsoft Excel

Messages In This Digest (3 Messages)

1a.

Re: Mohon Bantuan : Memverifikasi 2 tabel menjadi tabel baru (meliha From: iwenk setiyawan

2a.

[Bls] Re: Fungsi LARGE dengan Data Kembar From: farick03

3.

Nilai min dan max spin button From: "andre"

View All Topics | Create New Topic

Messages

1a.

Re: Mohon Bantuan : Memverifikasi 2 tabel menjadi tabel baru (meliha

Posted by: "iwenk setiyawan" iwenk.setiyawan@gmail.com

Sat Nov 26, 2011 8:13 am (PST)

ya memang untuk kasus ini tidak ada pembayaran cicilan, terima kasih
atas bantuannya, mohon ijin nanti sy praktekan di kantor,
suwun mas bro...

Back to top

Reply to sender | Reply to group | Reply via web post
Messages in this topic (3)

2a.

[Bls] Re: Fungsi LARGE dengan Data Kembar

Posted by: "farick03" farick03@yahoo.com   farick03

Sat Nov 26, 2011 8:13 am (PST)

Salam Mr. Kid,
Alhamdulillah array formula yg ini "SUKSES", matur suwuuun..
maap br reply, krn formula Mister langsung sy implementasiin dulu di data file sy yg aseli (maap gk kekirim krn kapasitas gede), dan hasilnya.. JRENGGGGGG, berhasil yes yess :)
Mister bener2 Master, manstabp..
ini jg lg olah2 formula utk fungsi yg laen, nanti klo kesulitan mohon dibantu lg yaa, manfaat skali ilmu Mister, bs berbagi tuk sesama..
Barokalloh..
Salam,

Farick

--- In belajar-excel@yahoogroups.com, "Kid Mr." <mr.nmkid@...> wrote:
>
> hehehe.... kondisi berdasar nilai kls nya belum masuk ya
> Coba yang array formula berikut :
> =IF(N(C3),INDEX('SUKSESI JAB'!$T$3:$T$195,SMALL(IF(('SUKSESI
> JAB'!$X$3:$X$276="MD")**('SUKSESI JAB'!$Y$3:$Y$276=C3)*,ROW('SUKSESI
> JAB'!$X$3:$X$276)-ROW('SUKSESI JAB'!$X$2)),COUNTIF($C$2:$C3,$C3))),"")
>
>
> Yang biru adalah kondisi berdasar nilainya kls yang akan diambil.
> Kid.
>
>
> 2011/11/24 farick03 <farick03@...>
>
> > **
> >
> >
> > Nite Mr. Kid,
> > trims atas bantuannya, arahan Mr sukses array formulanya di kolom D :
> > 1 50,3 NB
> > 2 50,3 HC
> >
> > tetapi sy coba copy paste di kolom G : (gagal)
> > 1 200,7 RR
> > 2 200,7 CC
> > 3 100,0 RR --> harusnya EC
> >
> > dan, dikolom J : (gagal juga)
> > 1 300,0 CC --> harusnya ZZ, klo manual
> > 2 150,3 CC --> harusnya MM
> > 3 100,2 CC --> Udh cucok)
> > 4 100,2 MM --> harusnya UU
> > 5 70,0 CC --> harusnya ZB
> >
> > maap, udah larut ini saya kirim imelnya, lg utak atik formula dimaksud blm
> > nyantol2 :(
> > Mohon dibantu lg ya rekans yg budiman..
> >
> > /Farick
> >
> >
> > --- In belajar-excel@yahoogroups.com, "Kid Mr." <mr.nmkid@> wrote:
> > >
> > > Coba array formula untuk ambil data selain Kls : (misal pada kolom D)
> > > =IF(N(C3),INDEX('SUKSESI JAB'!$T$3:$T$195,*SMALL(IF('SUKSESI
> >
> > > JAB'!$X$3:$X$276="MD",ROW('SUKSESI JAB'!$X$3:$X$276)-ROW('SUKSESI
> > > JAB'!$X$2)),COUNTIF($C$2:$C3,$C3))*),"")
> >
> > >
> > > Yang biru, pengganti penggunaan Match.
> > >
> > > Wassalamualaikum Wr. Wb.,
> > > Kid.
> >
> >
> >
>

Back to top

Reply to sender | Reply to group | Reply via web post
Messages in this topic (5)

3.

Nilai min dan max spin button

Posted by: ""andre"" qlick@inbox.com   andrepri@ymail.com

Sun Nov 27, 2011 5:54 am (PST)

Dear teman-teman BeExceller,

Dapatkah nilai min dan max pd spin button tergantung dari referensi nilai suatu cell?,
mis A2=2=nilai min dan A3=10=nilai max,

salam

- andre -

Back to top

Reply to sender | Reply to group | Reply via web post
Messages in this topic (1)

Recent Activity

•  20
  New Members

Visit Your Group

Find helpful tips

for Moderators

on the Yahoo!

Groups team blog.

Dog Fanatics

on Yahoo! Groups

Find people who are

crazy about dogs.

Yahoo! Finance

It's Now Personal

Guides, news,

advice & more.

Need to Reply?

Click one of the "Reply" links to respond to a specific message in the Daily Digest.

Create New Topic | Visit Your Group on the Web

Messages

---------------------------------------------------------------------
bergabung ke milis (subscribe), kirim mail kosong ke:
belajar-excel-subscribe@yahoogroups.com

posting ke milis, kirimkan ke:
belajar-excel@yahoogroups.com

berkunjung ke web milis
http://tech.groups.yahoo.com/group/belajar-excel/messages

melihat file archive / mendownload lampiran
http://www.mail-archive.com/belajar-excel@yahoogroups.com/
atau (sejak 25-Apr-2011) bisa juga di :
http://milis-belajar-excel.1048464.n5.nabble.com/

menghubungi moderators & owners: belajar-excel-owner@yahoogroups.com

keluar dari membership milis (UnSubscribe):
kirim mail kosong ke  belajar-excel-unsubscribe@yahoogroups.com
---------------------------------------------------------------------

MARKETPLACE

Stay on top of your group activity without leaving the page you're on - Get the Yahoo! Toolbar now.

Change settings via the Web (Yahoo! ID required)
Change settings via email: Switch delivery to Individual | Switch format to Traditional
Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe