pisahkan data sesuai jumlah

29 views
Skip to first unread message

hairul alam

unread,
Nov 21, 2019, 5:09:36 AM11/21/19
to milis Belajar-Excel
Salam, Master

Selamat Siang

Terlampir data saya,

Bagaimana RUMUS agar nomor kolom C pada item A, B, C, D,E & F dengan jumlah  di kolom D akan terpisah sesuai jumlah pada masing2 item

item A no 59310818 = 220 dan dipisah dari 1 s/d 220

item B no 59310819 = 110 dan dipisah dari 1 s/d 110

dan seterunya terpisah urutan row ke bawah sesuai jumlah (QTY) masing2
 

Item    Nomor                   Qty
A        59310818            220
B        59310819            110
C        59310820            425
D        59310821            335
E        59310822            220
F        59310823            180

Mohon Solusinya

Terimakasih

Assalamualaikum
Hairul Alam
pisahkan data sesuai jumlah.xlsx

hairul alam

unread,
Nov 21, 2019, 5:09:36 AM11/21/19
to milis Belajar-Excel

Salam, Master

Selamat Pagi

ghery.yen20

unread,
Nov 28, 2019, 6:36:25 PM11/28/19
to milis Belajar-Excel
Mungkin Pivot cara tercepat yang bisa membantu.

ghery.yen20

unread,
Nov 28, 2019, 6:36:26 PM11/28/19
to milis Belajar-Excel
Assalamu'alaikum.


Sambil menunggu para master, mungkin File ini bisa membantu.





On Thursday, 21 November 2019 17:09:36 UTC+7, hairul alam wrote:
Sesuai Jumlah.xlsb

HAIRUL ALAM

unread,
Nov 29, 2019, 5:22:06 AM11/29/19
to milis Belajar-Excel, ghery.yen20
Terimakasih Mas Ghery



--
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/71e33f69-797c-47e3-9b11-df700b22a144%40googlegroups.com.
Reply all
Reply to author
Forward
0 new messages