transpose berkriteria

odong nando

unread,

Feb 23, 2021, 10:12:56 PM2/23/21

to milis Belajar-Excel

hai rekan sekalian,

mohon bantuan utk kasus seputar transpose namun berkriteria, biasanya saya pake formula filer sederhana, seperti terlampir, tp kok ahir2 ini saya males banget bwt ngetik formula, saya coba pake pivot table, krn keterbatasan ilmu sy blm bisa menjadi format yang di inginkan, adakah solusinya selain formula filtring yg sudah sy gunakan, seperti terlampir

terimakasih

odong nando

transpose berkriteria.xlsx

hendrik karnadi

unread,

Feb 24, 2021, 6:28:05 AM2/24/21

to Milis Belajar-Excel

Mas Odong,

Sdh coba pakai Power Query ?

Salam,

HK

Sent from Yahoo Mail on Android

--
You received this message because you are subscribed to the Google Groups "milis Belajar-Excel" group.
To unsubscribe from this group and stop receiving emails from it, send an email to milis-belajar-e...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/milis-belajar-excel/CAGZ5tN552LO3wt0zHJsajYDAkb---yr7EeNfgWUUai09weKrRQ%40mail.gmail.com.

odong nando

unread,

Feb 24, 2021, 7:15:51 AM2/24/21

to Milis Belajar-Excel

hai pak HK

sudah sy coba tp mentok, tidak membuahkan hasil...

mungkin p HK bisa bimbing saya menyelesaikan masalah ini...

To view this discussion on the web visit https://groups.google.com/d/msgid/milis-belajar-excel/1855905365.1956199.1614166072472%40mail.yahoo.com.

Mr. Kid

unread,

Feb 25, 2021, 8:37:13 AM2/25/21

to Milis Belajar-Excel

Gimana kalau jalan-jalan kesini. Sapa tahu gak kejauhan tersesatnya.

;)

To view this discussion on the web visit https://groups.google.com/d/msgid/milis-belajar-excel/CAGZ5tN58U703k3d-M_eUqEKV%2B4SWgazETGtkRPOo-CqHOPwN8A%40mail.gmail.com.

odong nando

unread,

Feb 25, 2021, 9:01:30 PM2/25/21

to milis Belajar-Excel

mantafffff...

harus di pelajari ini...

tengkiyu bos kid...

To view this discussion on the web visit https://groups.google.com/d/msgid/milis-belajar-excel/CAOiZkPsx-3NiPi7JiG0vgH9EC%3DiFwkt-_WpAbmQmW8ZYp09NhA%40mail.gmail.com.

iqba...@gmail.com

unread,

Feb 26, 2021, 5:31:53 AM2/26/21

to Mr. Kid, Milis Belajar-Excel

Wedew…. Udah jadi youtuber ini,

Jangan lupa like, subrek and share ya…..

To view this discussion on the web visit https://groups.google.com/d/msgid/milis-belajar-excel/CAOiZkPsx-3NiPi7JiG0vgH9EC%3DiFwkt-_WpAbmQmW8ZYp09NhA%40mail.gmail.com.

Mr. Kid

unread,

Feb 26, 2021, 8:30:50 AM2/26/21

to Milis Belajar-Excel

Ngetik itu capek n susah milih bahasa manusianya.

Lebih gampang asal ngoceh.

Hahaha

Sent from my smart enough phone

iqba...@gmail.com

unread,

Feb 26, 2021, 8:52:40 PM2/26/21

to Milis Belajar-Excel

Udah ada 2 youtuber ini di belajar excel.

Mr Hendrik Karnadi
Mr Kid.

Aku buat channel juga di youtube :

https://www.youtube.com/channel/UCO0q6JIcBmBJZQhHJ3ja-KA/videos

hahahahahahaha…. Kek nya memang lebih enak klo asal ngoceh.

Ntar habis selesai study aku upload juga lah….

To view this discussion on the web visit https://groups.google.com/d/msgid/milis-belajar-excel/81B508D9-2D06-4F05-A5F9-6BBBA5DF6F36%40gmail.com.

hendrik karnadi

unread,

Feb 26, 2021, 9:15:48 PM2/26/21

to Milis Belajar-Excel

Terima kasih mas Iqbal.

Salam,

HK

Sent from Yahoo Mail on Android

https://groups.google.com/d/msgid/milis-belajar-excel/004e01d70cab%24377ae1e0%24a670a5a0%24%40gmail.com
.

Mr. Kid

unread,

Feb 27, 2021, 2:00:26 PM2/27/21

to Iqbal iqbal, Milis Belajar-Excel

hahaha...

oh lagi study ya...

moga2 lancar ipk empat

terus naik pangkat

To view this discussion on the web visit https://groups.google.com/d/msgid/milis-belajar-excel/004e01d70cab%24377ae1e0%24a670a5a0%24%40gmail.com.

zainul ulum

unread,

Feb 27, 2021, 2:00:55 PM2/27/21

to milis Belajar-Excel

aku sudah subcribed..

kalo tanya2 di miliat atau di kolom komentar yourtube?

maturnuwun,

_zainul

To view this discussion on the web visit https://groups.google.com/d/msgid/milis-belajar-excel/81B508D9-2D06-4F05-A5F9-6BBBA5DF6F36%40gmail.com.

Mr. Kid

unread,

Feb 27, 2021, 2:03:49 PM2/27/21

to zainul ulum, milis Belajar-Excel

boleh dimana saja mas zain
Kalau di-milis, bisa dibantu rekan BeExceller dalam menjawab. Bisa jadi lebih cepat dapat solusi.

Kalau di-youtube, bisanya juga saya reply di-comment, dan nunggu ada banyak yang nge-like comment di-youtube tadi baru diusahakan dibikin pidio-nya

Thanks

To view this discussion on the web visit https://groups.google.com/d/msgid/milis-belajar-excel/CADEWuOPVLErsNo%2BCdFg5BS7FPqKiiKyL%2BqsVceuFgstATOpv2Q%40mail.gmail.com.

iqba...@gmail.com

unread,

Mar 1, 2021, 12:14:22 AM3/1/21

to Milis Belajar-Excel

Aamiin…

Matur suwun doa nya MasKid

Sukses juga buat keluarga milis ini.

Mr. Kid

unread,

Jul 8, 2021, 4:40:25 PM7/8/21

to Milis Belajar-Excel

gimana kabarnya yang lagi study nih... piye rasanya study online dari masuk sampai lulus ?

wkwkwk...

To view this discussion on the web visit https://groups.google.com/d/msgid/milis-belajar-excel/003f01d70e59%24b8bc10d0%242a343270%24%40gmail.com.

iqba...@gmail.com

unread,

Jul 9, 2021, 11:27:33 AM7/9/21

to Mr. Kid, Milis Belajar-Excel

Alhamdulillah Mas sehat,

Umur tidak bisa membohongi iki…. Lebih berat menjalani study online disbanding offline…

Wkwkwkwkwkwk…

Sejauh mata memandang cumin laptop and mic… ora onok seger segere blas…

xixixiix

To view this discussion on the web visit https://groups.google.com/d/msgid/milis-belajar-excel/CAOiZkPspOAOD%2Bv00E7gQEHazsLo9r7-0HgjYDXUTXP1HmhzOow%40mail.gmail.com.

Reply all

Reply to author

Forward