[belajar-excel] Digest Number 3149

Milis Belajar Microsoft Excel Group

2 Messages

Digest #3149

1a

Re: Data Validation by "Dede"

1b

Re: Data Validation by "Mr. Kid" nmkid.family@ymail.com

Messages

1a

Re: Data Validation

Wed Oct 22, 2014 3:21 am (PDT) . Posted by:

"Dede"

Dear Pak zainul,

Formulanya tidak bekerja pak.

Salam,

DD

From: 'zainul_ulum[at]yahoo[dot]com' zainul_ulum@yahoo.com [belajar-excel] [mailto:belajar-excel@yahoogroups.com]
Sent: 22 Oktober 2014 16:40
To: belajar-excel@yahoogroups.com
Subject: RE: [belajar-excel] Data Validation

copy rumus di [L2} ke bawah dan ke kanan

From: belajar-excel@yahoogroups.com [mailto:belajar-excel@yahoogroups.com]
Sent: Wednesday, October 22, 2014 4:31 PM
To: belajar-excel@yahoogroups.com
Subject: [belajar-excel] Data Validation

Dear BeExceller,

Minta tolong master, saya ingin memprotect untuk isian dari tabel dibawah ini.

Bagaimana caranya agar kolom warna kuning hanya bisa diisi kalau jenis kelamin "L", jadi kalau jenis kelaminnya "P" cell ditak bisa diisi dikolom warna kuning.

Begitupun untuk kolom warna hijau.

Nama

Jenis Kelamin

L

P

a

L

1

b

P

1

c

L

1

d

P

1

e

P

1

Kalau menggunakan data validasi bagaimana caranya yah, mohon masukannya.

Salam,

DD

_____

This e-mail and any files transmitted with it are confidential and intended solely for the use of the individual to whom it is addressed. If you have received this email in error please send it back to the person that sent it to you. Any views or opinions presented are solely those of its author and do not necessarily represent those of NABATI or any of its subsidiary companies. Unauthorized publication, use, dissemination, forwarding, printing or copying of this email and its associated attachments is strictly prohibited.

Reply to sender . Reply to group . Reply via Web Post . All Messages (8) . Top ^

1b

Re: Data Validation

Wed Oct 22, 2014 3:28 am (PDT) . Posted by:

"Mr. Kid" nmkid.family@ymail.com

Pak Dede,

Formula Pak Zainul :
= -- ( $B2 = C$1 )

Formula Pak Dede :
= -- $B2 = C$1

Bagaimana kalau dicoba yang persis dulu. Ndak usah ada karakter formula
yang dihilangkan dari formula usulan Pak Zainul.

Wassalam,
Kid.

On Wed, Oct 22, 2014 at 9:16 PM, Dede pmaho_log4@nabatisnack.co.id
[belajar-excel] <belajar-excel@yahoogroups.com> wrote:

>
>
>
> Dear Pak zainul,
>
>
>
> Formulanya tidak bekerja pak.
>
>
>
> Salam,
>
> DD
>
>
>
> *From:* 'zainul_ulum[at]yahoo[dot]com' zainul_ulum@yahoo.com
> [belajar-excel] [mailto:belajar-excel@yahoogroups.com]
> *Sent:* 22 Oktober 2014 16:40
> *To:* belajar-excel@yahoogroups.com
> *Subject:* RE: [belajar-excel] Data Validation
>
>
>
>
>
>
>
> copy rumus di [L2} ke bawah dan ke kanan
>
>
>
> *From:* belajar-excel@yahoogroups.com [mailto:
> belajar-excel@yahoogroups.com]
> *Sent:* Wednesday, October 22, 2014 4:31 PM
> *To:* belajar-excel@yahoogroups.com
> *Subject:* [belajar-excel] Data Validation
>
>
>
>
>
> Dear BeExceller,
>
>
>
> Minta tolong master, saya ingin memprotect untuk isian dari tabel dibawah
> ini.
>
> Bagaimana caranya agar kolom warna kuning hanya bisa diisi kalau jenis
> kelamin "L", jadi kalau jenis kelaminnya "P" cell ditak bisa diisi dikolom
> warna kuning.
>
> Begitupun untuk kolom warna hijau.
>
>
>
> Nama
>
> Jenis Kelamin
>
> L
>
> P
>
> a
>
> L
>
> 1
>
>
>
> b
>
> P
>
>
>
> 1
>
> c
>
> L
>
> 1
>
>
>
> d
>
> P
>
>
>
> 1
>
> e
>
> P
>
>
>
> 1
>
>
>
> Kalau menggunakan data validasi bagaimana caranya yah, mohon masukannya.
>
>
>
> Salam,
>
> DD
>
>
> ------------------------------
> ------------------------------
>
>
>
>
>
>
>
>
>
>
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (8) . Top ^

============================================================
Pojok Lowongan Kerja yang disediakan milis :
http://milis-belajar-excel.1048464.n5.nabble.com/Pojok-Lowongan-Kerja-f5725753.html
*** Posting lowongan kerja : ke link tersebut dan klik New Topic
============================================================
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
---------------------------------------------------------------------

Visit Your Group

• New Members 10

• Privacy • Unsubscribe • Terms of Use