Monday, June 29, 2009

Menampilkan Huruf pada urutan keterangan tertentu

misalnya pada teks suatu sel di Excel A2 tertulis: Jabatan(NAMA)
Bagaimana agar hanya NAMA-nya saja yang tampil?
Gunakan sintak =FIND("(", A2, 35)
Posted by at No comments:
Labels:

Wednesday, June 17, 2009

Question About Excel

http://www.mrexcel.com/qa.shtml
Posted by at 1 comment:
Labels: ,

Mapping Color Index

Mapping Color Index
http://www.mvps.org/dmcritchie/excel/colors.htm
Posted by at No comments:
Labels: ,

Tuesday, June 16, 2009

Menyisipkan Rumus Index dan Match di VB

Menyisipkan Rumus Index dan Match, gunakan sintaks berikut ini :
Cells(Line, 6).Value = "=INDEX(SOFTWARE.LIST!$A$2:$B$10000,MATCH(E" & Line & ",SOFTWARE.LIST!$A$2:$A$10000,0),2)"
Posted by at No comments:
Labels:

Monday, June 15, 2009

Melihat PID command DOS

Perintah yang hanya berfungsi pada Windows XP, gunakan perintah berikut
C:\tasklist

Untuk referensi yang lain, silakan kunjungi
http://www.infocellar.com/winxp/DOS-with-XP.htm
http://www.networkclue.com/os/Windows/commands/
Posted by at No comments:
Labels:
Subscribe to: Comments (Atom)