Re: ]] XL-mania [[ Melihat Nilai TEXT Max

 

kolom bantu di kolom B  (B2:B11)

B2

=SUM({100,10,1}*CODE(MID(A2,{3,4,5},1)))

 

jawaban di E1

=OFFSET($A$1,MATCH(MAX(B2:B11),B2:B11,0),0)

 

jawaban di G1

=Right(OFFSET($A$1,MATCH(MAX(B2:B11),B2:B11,0),0),2)

 

Case Name	kolom bantu
XXA01	7029
XXA99	7127
XXB00	7128
XXB01	7129
XXB99	7227
XXE01	7429
XXB01	7129
XXB03	7131
XXC04	7232
XXD11	7339

 

Last Case	XXE01	atau	E01	>> Hasil Yang diinginkan
	XXE01		E01	<< jawaban dibantu koom helper

---

----- Original Message -----

From: Ulya Liwa

To: xl xlmania

Sent: Friday, January 29, 2010 9:28 PM

Subject: ]] XL-mania [[ Melihat Nilai TEXT Max

XL master,
Mohon bantuannya, saya ada bingung bikin rumus untuk menentukan nilai maksimum

bentuk TEXT (seprti A00,...,A99, B00,..B99, C99 dst) ,, file excel terlampir.

jika ini pernah dibahas mohon maaf jika saya mempertanyakan lagi. hihihi,,

maklum baru ikutan,, :-D
Salam
Ulya

__._,_.___

Reply to sender | Reply to group

Messages in this topic (2)

Recent Activity:

• New Members 103

Visit Your Group Start a New Topic

+-:: XL-mania ::::::::::::::::::::----------------------------------+
| Member ke 13,013 siapa ya? Sini mau dikirimin coklat :D           |
| Member ke 31,031 dapet iPod dehh.... :D :D :D                     |  
| http://www.facebook.com/group.php?gid=37671048001&ref=mf          |
+-------------------------------------------------------------------+
| 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.friendster.com/xlmania atau...  |
| 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              |
+-------------------------------------------------------------------+

MARKETPLACE

Going Green: Your Yahoo! Groups resource for green living

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___