Nhóm dữ liệu

[pt_tung1982]

[TD="width: 270, colspan: 2"]Có DỮ LIỆU NHƯ BẢNG SAU:
[/TD]
[TD="width: 125"][/TD]
[TD="width: 63"][/TD]
[TD="width: 80"][/TD]
[TD="width: 87"][/TD]

[TD="class: xl66"]MSHH[/TD]
[TD="class: xl66"]TENHH[/TD]
[TD="class: xl66"]DONGIA[/TD]
[TD="class: xl66"]SOLUONG[/TD]
[TD="class: xl66"]THANHTIEN[/TD]

[TD="class: xl65"]H01[/TD]
[TD="class: xl64"]Vitamin AD (A.D.O)
[/TD]
[TD="class: xl65, align: right"]200[/TD]
[TD="class: xl65, align: right"]100[/TD]
[TD="class: xl65, align: right"]20000[/TD]

[TD="class: xl65"]H01[/TD]
[TD="class: xl64"]Vitamin AD (A.D.O)
[/TD]
[TD="class: xl65, align: right"]200[/TD]
[TD="class: xl65, align: right"]200[/TD]
[TD="class: xl65, align: right"]40000[/TD]

[TD="class: xl65"]H01[/TD]
[TD="class: xl64"]Vitamin AD (A.D.O)[/TD]
[TD="class: xl65, align: right"]199[/TD]
[TD="class: xl65, align: right"]400[/TD]
[TD="class: xl65, align: right"]79600[/TD]

[TD="class: xl65"]H02[/TD]
[TD="class: xl64"]Bcomplex[/TD]
[TD="class: xl65, align: right"]500[/TD]
[TD="class: xl65, align: right"]1000[/TD]
[TD="class: xl65, align: right"]500000[/TD]

[TD="class: xl65"]H02[/TD]
[TD="class: xl64"]Bcomplex[/TD]
[TD="class: xl65, align: right"]500[/TD]
[TD="class: xl65, align: right"]1800[/TD]
[TD="class: xl65, align: right"]900000[/TD]

[TD="class: xl65"]H03[/TD]
[TD="class: xl64"]Omeprazol 20mg[/TD]
[TD="class: xl65, align: right"]1400[/TD]
[TD="class: xl65, align: right"]500[/TD]
[TD="class: xl65, align: right"]700000[/TD]

[TD="class: xl65"]H03[/TD]
[TD="class: xl64"]Omeprazol 20mg[/TD]
[TD="class: xl65, align: right"]1300[/TD]
[TD="class: xl65, align: right"]400[/TD]
[TD="class: xl65, align: right"]520000[/TD]

[TD="class: xl65"]H03[/TD]
[TD="class: xl64"]Omeprazol 20mg[/TD]
[TD="class: xl65, align: right"]1350[/TD]
[TD="class: xl65, align: right"]3000[/TD]
[TD="class: xl65, align: right"]4050000[/TD]

[TD="class: xl65"]H03[/TD]
[TD="class: xl64"]Omeprazol 20mg[/TD]
[TD="class: xl65, align: right"]1350[/TD]
[TD="class: xl65, align: right"]100[/TD]
[TD="class: xl65, align: right"]135000[/TD]

[TD="class: xl65"]H04[/TD]
[TD="class: xl64"]Oresol[/TD]
[TD="class: xl65, align: right"]100[/TD]
[TD="class: xl65, align: right"]300[/TD]
[TD="class: xl65, align: right"]30000[/TD]

[TD="class: xl65"]H04[/TD]
[TD="class: xl64"]Oresol[/TD]
[TD="class: xl65, align: right"]100[/TD]
[TD="class: xl65, align: right"]400[/TD]
[TD="class: xl65, align: right"]40000[/TD]

[TD="class: xl65"]H04[/TD]
[TD="class: xl64"]Oresol[/TD]
[TD="class: xl65, align: right"]101[/TD]
[TD="class: xl65, align: right"]500[/TD]
[TD="class: xl65, align: right"]50500[/TD]

[TD="class: xl68, width: 625, colspan: 6"]YÊU CẦU: LỘC DỮ LIỆU THÀNH BẢNG BÊN DƯỚI, CÁI NÀO CÙNG "MSHH" VÀ CÙNG "DONGIA" THÌ NHÓM LẠI THÀNH 1 DÒNG
"SOLUONG" VÀ THANHTIEN" THÌ BẰNG TỔNG CÁC DÒNG ĐÃ NHÓM[/TD]

[TD="class: xl67"]MSHH[/TD]
[TD="class: xl67"]TENHH[/TD]
[TD="class: xl67"]DONGIA[/TD]
[TD="class: xl67"]SOLUONG[/TD]
[TD="class: xl67"]THANHTIEN[/TD]

[TD="class: xl65"]H01[/TD]
[TD="class: xl64"]Vitamin AD (A.D.O)[/TD]
[TD="class: xl65, align: right"]200[/TD]
[TD="class: xl65, align: right"]300[/TD]
[TD="class: xl65, align: right"]60000[/TD]

[TD="class: xl65"]H01[/TD]
[TD="class: xl64"]Vitamin AD (A.D.O)[/TD]
[TD="class: xl65, align: right"]199[/TD]
[TD="class: xl65, align: right"]400[/TD]
[TD="class: xl65, align: right"]79600[/TD]

[TD="class: xl65"]H02[/TD]
[TD="class: xl64"]Bcomplex[/TD]
[TD="class: xl65, align: right"]500[/TD]
[TD="class: xl65, align: right"]2800[/TD]
[TD="class: xl65, align: right"]1400000[/TD]

[TD="class: xl65"]H03[/TD]
[TD="class: xl64"]Omeprazol 20mg[/TD]
[TD="class: xl65, align: right"]1400[/TD]
[TD="class: xl65, align: right"]500[/TD]
[TD="class: xl65, align: right"]700000[/TD]

[TD="class: xl65"]H03[/TD]
[TD="class: xl64"]Omeprazol 20mg[/TD]
[TD="class: xl65, align: right"]1300[/TD]
[TD="class: xl65, align: right"]400[/TD]
[TD="class: xl65, align: right"]520000[/TD]

[TD="class: xl65"]H03[/TD]
[TD="class: xl64"]Omeprazol 20mg[/TD]
[TD="class: xl65, align: right"]1350[/TD]
[TD="class: xl65, align: right"]3100[/TD]
[TD="class: xl65, align: right"]4185000[/TD]

[TD="class: xl65"]H04[/TD]
[TD="class: xl64"]Oresol[/TD]
[TD="class: xl65, align: right"]100[/TD]
[TD="class: xl65, align: right"]700[/TD]
[TD="class: xl65, align: right"]70000[/TD]

[TD="class: xl65"]H04[/TD]
[TD="class: xl64"]Oresol[/TD]
[TD="class: xl65, align: right"]101[/TD]
[TD="class: xl65, align: right"]500[/TD]
[TD="class: xl65, align: right"]50500[/TD]

xin các anh chị nào có cách lộc được dữ liệu như thế giúp em với, xin gửi đáp án
về mail pt_tung1982@yahoo.com.vn

 

[Hoàng Trọng Nghĩa]

xin các anh chị nào có cách lộc được dữ liệu như thế giúp em với, xin gửi đáp án
về mail pt_tung1982@yahoo.com.vn

Bạn làm ơn gửi cái File lên đi, chứ nhìn cái bảng của bạn tôi chẳng thấy "kí rì" hết!