]] XL-mania [[ Digest Number 2754

Microsoft Excel Community Group

6 Messages

Digest #2754

1

Mengganti Character dgn Syarat di Cells by "Galuh Sukmana"

2

sortir ribuan no hp supaya menjadi no yang valid. by jayyusz

3

menghitung used dan stanby serta loss by arimike@ymail.com

4

Cara Merubah DropDown Page di Pivot by "Samsul Arifin" syemy88

5

Template AP&AR by "adhy tri anggoro bramantiyo" adhie_3ab

6

menghitung banyak stanby,used,loss by "Ari Mike" arimike@ymail.com

Messages

1

Mengganti Character dgn Syarat di Cells

Tue Jul 29, 2014 8:36 am (PDT) . Posted by:

"Galuh Sukmana"

Dear All Excelers,

Saya ingin mengganti beberapa char dicell bersyarat menggunakan replace
atau substitute, tetapi saya kesulitan membuatnya karena masing2 cell tidak
sama jumlah characternya

Cth:
Budi Indah Lalu = B**i I***h L**u
Windarini Suratmi = W*******i S*****i
Mejikuhibiniu = M***********u
Bantex Bagus Putih = B****x B***s P***h

Mohon bantuannya utk bisa memberikan pencerahannya. Atas bantuannya
diucapkan terima kasih

Regards,
Galuh

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

2

sortir ribuan no hp supaya menjadi no yang valid.

Tue Jul 29, 2014 8:36 am (PDT) . Posted by:

jayyusz

halo,

saya mau bertanya, bagaimana cara singkat untuk mensortir ribuan no hp yang belum tentu valid formatnya supaya menjadi valid.

contoh :
626208164547598
6208164547598
08164547598
8164547598
628164547598
62628164547598

saya ingin mengambil no yang sudah di sortir menjadi 8164547598 selain itu tidak ditampilkan.
seampai sekarang saya manual mensortir per tingkat.
contoh saya sortir dahulu yang angka depan nya 62 kemudian setelah mendapatkan haasilnya di sortir kembali dan seterusnya.

untuk lebih jelas nya saya melampirkan contoh data excel nya.

nb: saya ingin mensortir berdasarkan no yang valid yang ada di indonesia berdasarkan provider yang ada.
(telkomsel 812,813,821) seperti itu.

tq before

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

3

menghitung used dan stanby serta loss

Tue Jul 29, 2014 8:37 am (PDT) . Posted by:

arimike@ymail.com

Rekan2 yang baik dan super sekali mohon bantuannya untuk problem yang saya lampirkan.

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

4

Cara Merubah DropDown Page di Pivot

Tue Jul 29, 2014 8:37 am (PDT) . Posted by:

"Samsul Arifin" syemy88

Dear Master Master Excel

Mohon bantuannya, Cara Merubah DropDown Page di Pivot menggunakan

ComboBox VBA.
Contohnya : di dalam DropDown Pivot ada Tgl-Tgl, bagaimana cara memilihnya melalui ComboBox VBA.

Terima Kasih

 
Hormat Saya
Samsul Aripin

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

5

Template AP&AR

Tue Jul 29, 2014 8:37 am (PDT) . Posted by:

"adhy tri anggoro bramantiyo" adhie_3ab

Dear all.

Apa ada yang punya template aplikasi daftar umur hutang-piutang. Kalau ada boleh di share.

Terima kasih,

Adhy tri anggoro b

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

6

menghitung banyak stanby,used,loss

Tue Jul 29, 2014 8:37 am (PDT) . Posted by:

"Ari Mike" arimike@ymail.com

mohon bantuan untuk formula pada lampiran

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

:: XL-mania ::::::::::::::::::::
Momods sekarang jualan tas di www.flirtypoodle.com ha ha ha....
:: ------------- ::::::::::::::::::::
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

Visit Your Group

• New Members 3

• Privacy • Unsubscribe • Terms of Use

[smf_addin] Digest Number 3135

EXCEL Stock Market Functions Add-in Group

4 Messages

Digest #3135

1a

Re: S&M and G&A broken out by friedman_steve

1b

Re: S&M and G&A broken out by friedman_steve

2.1

New file uploaded to smf_addin by

2.2

New file uploaded to smf_addin by

Messages

1a

Re: S&M and G&A broken out

Tue Jul 29, 2014 6:13 am (PDT) . Posted by:

friedman_steve

Thanks. Sounds like I'm going to be out of luck finding the more detailed data. (even after they update their websites).

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

1b

Re: S&M and G&A broken out

Tue Jul 29, 2014 7:43 am (PDT) . Posted by:

friedman_steve

Actually, Randy, the links that you sent are the new beta version?


I noticed that the detail is not there for some names (like MMM), but IS there for other names (like MDSO).
http://www.advfn.com/common/financial/NASDAQ/medidata-solutions-inc-mm-MDSO/full-financials?pm=Q&isfull=1&bsfull=1&cffull=1&effull=1&vrfull=1&grfull=1&fhfull=1&prfull=1 http://www.advfn.com/common/financial/NASDAQ/medidata-solutions-inc-mm-MDSO/full-financials?pm=Q&isfull=1&bsfull=1&cffull=1&effull=1&vrfull=1&grfull=1&fhfull=1&prfull=1



But, also, only updated thru December (as you mentioned). So I'm confused if this is their new template or not.

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

2.1

New file uploaded to smf_addin

Tue Jul 29, 2014 3:57 pm (PDT) . Posted by:

Hello,

This email message is a notification to let you know that
a file has been uploaded to the Files area of the smf_addin
group.

File : /Works-In-Progress/Need to be looked at/Arjun - SMF Stock Tool_c.xls
Uploaded by : shado_kai_2002 <shado_kai_2002@yahoo.com>
Description : I combined various SMF tools into one powerful tool thanks to great people like yourself. However, I am having trouble with some of the cells due to changes and need some help. I really want to get better at the programming side and not just using SMF add in reference #'s, so any instruction would be great. Later on I will add in FRED data SMF and other valuations and comparisons. Please help me clean it up and add to it if you like.

You can access this file at the URL:
https://groups.yahoo.com/neo/groups/smf_addin/files/Works-In-Progress/Need%20to%20be%20looked%20at/Arjun%20-%20SMF%20Stock%20Tool_c.xls

To learn more about file sharing for your group, please visit:
https://help.yahoo.com/kb/index?page=content&y=PROD_GRPS&locale=en_US&id=SLN15398

Regards,

shado_kai_2002 <shado_kai_2002@yahoo.com>

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

2.2

New file uploaded to smf_addin

Tue Jul 29, 2014 4:00 pm (PDT) . Posted by:

Hello,

This email message is a notification to let you know that
a file has been uploaded to the Files area of the smf_addin
group.

File : /Works-In-Progress/Need to be looked at/SMF Stock Tool_c.xls
Uploaded by : shado_kai_2002 <shado_kai_2002@yahoo.com>
Description : Various SMF tools into one powerful tool thanks to great people like yourself. Having trouble with some of the cells, need on the programming side. After the fix will add FRED data points

You can access this file at the URL:
https://groups.yahoo.com/neo/groups/smf_addin/files/Works-In-Progress/Need%20to%20be%20looked%20at/SMF%20Stock%20Tool_c.xls

To learn more about file sharing for your group, please visit:
https://help.yahoo.com/kb/index?page=content&y=PROD_GRPS&locale=en_US&id=SLN15398

Regards,

shado_kai_2002 <shado_kai_2002@yahoo.com>

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

For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Visit Your Group

• New Members 37

• Privacy • Unsubscribe • Terms of Use