]] XL-mania [[ Digest Number 2419

Microsoft Excel Community

Messages In This Digest (4 Messages)

1a.

Re: Mencari Posisi dan Level berdasarkan Gaji From: NANG Agus

1b.

Re: Mencari Posisi dan Level berdasarkan Gaji From: Danny Marwan

1c.

Re: Mencari Posisi dan Level berdasarkan Gaji From: bagus

2a.

Re: Agar terisi otomatis From: Tommy

View All Topics | Create New Topic

Messages

1a.

Re: Mencari Posisi dan Level berdasarkan Gaji

Posted by: "NANG Agus" nangagus@gmail.com

Tue Jun 12, 2012 6:25 pm (PDT)

Yth Ase

Coba pakai index dan macth saja

salam
NangAgus

2012/6/12 Ase blajar Excel <aseblajarexcel@yahoo.com>

> **
>
>
> Dear Xcel mate,
>
> Saya mohon bantuannya untuk masalah saya, dimana saya ingin mengetahui
> Posisi, Level dan Grade seseorang jika diketahui nilai dari gajinya...
> File terlampir...
> Terimakasih sebelumnya ...
>
> salam,
> Ase
>
>
>

Back to top

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

1b.

Re: Mencari Posisi dan Level berdasarkan Gaji

Posted by: "Danny Marwan" dannymarwan@gmail.com

Tue Jun 12, 2012 6:27 pm (PDT)

Semoga Membantu.

Regards,
dannie maruwan

2012/6/12 Ase blajar Excel <aseblajarexcel@yahoo.com>

> **
>
>
> Dear Xcel mate,
>
> Saya mohon bantuannya untuk masalah saya, dimana saya ingin mengetahui
> Posisi, Level dan Grade seseorang jika diketahui nilai dari gajinya...
> File terlampir...
> Terimakasih sebelumnya ...
>
> salam,
> Ase
>
>
>

Back to top

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

1c.

Re: Mencari Posisi dan Level berdasarkan Gaji

Posted by: "bagus" bagus@kingjim.co.id   bagus4bls

Tue Jun 12, 2012 6:27 pm (PDT)

Dear Ase;

Mungkin begini:

=IF(ISNUMBER($J4),LOOKUP($J4,$F$4:$F$20,B$4:B$20),"")

copy kekanan & kebawah.

File terlampir semoga sesuai harapan

Bagus


Sent from my Taxiphone®

----- Original Message -----
From: Ase blajar Excel
To: xl-mania@yahoogroups.com
Sent: Tuesday, June 12, 2012 12:03 PM
Subject: ]] XL-mania [[ Mencari Posisi dan Level berdasarkan Gaji

Dear Xcel mate,

Saya mohon bantuannya untuk masalah saya, dimana saya ingin mengetahui Posisi, Level dan Grade seseorang jika diketahui nilai dari gajinya...
File terlampir...
Terimakasih sebelumnya ...

salam,
Ase

Back to top

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

2a.

Re: Agar terisi otomatis

Posted by: "Tommy" tomz.zlow@gmail.com   tomz_aja

Tue Jun 12, 2012 6:26 pm (PDT)

Ooops Sorry, saya copy sheet "yg diinginkan". Jadi hapus saja nama sheet tersebut agar formula bekerja.

Copy paste formula berikut dari cell A6 (bukan array formula):

=IF(COUNTA($A$5:$A5)>COUNTIF(Master!$B:$B,$B$3),"",OFFSET(Master!$C$1,ROW()-7+MATCH($B$3,Master!$B:$B,),COLUMN()-1))

bisa langsung di-cek di TKP terlampir.

Blessings,
tomz

----- Original Message -----
From: Tommy
To: XL-mania@yahoogroups.com
Sent: Tuesday, June 12, 2012 3:57 PM
Subject: Re: ]] XL-mania [[ Agar terisi otomatis

Dear Mas Koko,

Bisa coba alternatif formula panjang ini di cell A6, dan copas ke kanan dan bawah:

=IF(COUNTA($A$5:$A5)>COUNTIF(Master!$B:$B,'Yg di inginkan (2)'!$B$3),"",OFFSET(Master!$C$1,ROW()-7+MATCH('Yg di inginkan (2)'!$B$3,Master!$B:$B,),COLUMN()-1))

Blessings,
tomz

----- Original Message -----
From: Kokok Eko-Prasetyo
To: xl-mania@yahoogroups.com
Sent: Monday, June 11, 2012 2:23 PM
Subject: ]] XL-mania [[ Agar terisi otomatis

Master Excel mania,

Saya mau minta bantuan.
Bagaimana caranya (pakai fungsi apa) agar kolom yg saya kasih warna hijau bisa terisi otomatis saat kita isi cell B3 (yg saya blok kuning) dengan salah satu kode yg ada di "Master => Sheet Code".

Salam,
Koko

Back to top

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

Recent Activity

•  59
  New Members

Visit Your Group

Yahoo! Groups

Do More For Dogs Group

Join a group of dog owners

who do more.

Yahoo! Finance

It's Now Personal

Guides, news,

advice & more.

Yahoo! Groups

Small Business Group

Share experiences

with owners like you

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

+-:: XL-mania ::::::::::::::::::::----------------------------------+
| Woooowwww... member XL-mania tembus 20,000!!!                     |
+-------------------------------------------------------------------+
| DILARANG : MLM, money game, OOT, iklan tanpa izin, SARA, testing, |
| pembicaraan pribadi, one line message,  melecehkan,  tidak sopan. |
+-------------------------------------------------------------------+
| Buat subjek yang kreatif, jangan : "tanya", "help", "mohon bantu" |
| Usahakan besar attachment < 200 kb. Gunakan  winzip  jika  perlu. |
+-------------------------------------------------------------------+
| Ajak teman-teman Anda bergabung dengan mengirim e-mail kosong ke  |
| XL-mania-subscribe@yahoogroups.com atau kirimkan mereka file dari |
| http://groups.yahoo.com/group/XL-mania/files/Promotion/           |
+-------------------------------------------------------------------+
| Berikan testimoni di :                                            |
| http://www.xl-mania.com/2008/06/testimoni-xl-mania.html           |
+-------------------------------------------------------------------+
| Message lama ada di :                                             |
| http://groups.yahoo.com/group/XL-mania/messages [perlu yahoo id]  |
| http://www.mail-archive.com/xl-mania@yahoogroups.com              |
+-------------------------------------------------------------------+

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