I have a table like this
I NEED TO TURN TO THIS REPORT
STEPS:
1. FILTER COLUMN DRIVER ( COLUMN A) FROM A TO Z)
2. INSERT 1 TOTAL ROW FOR EACH DRIVER. COUNT THE TOTAL FOR THAT DRIVER IN COLUMN L (NUMBER7)
3.FIND IN COLUMN C IF SAME WORD , MERGE AND SUM AND CENTER IN COLUM L
I HAVE A LARGE NUMBER ROW DATA. SO PLEASE HELP. THIS REALLY HELP ME SAVE TIME LIKE AN HOUR . I AM APPRICIATE FOR THE HELP. THANK YOU
| TEST.xlsx | ||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | G | H | I | J | K | L | |||
| 1 | TEST | |||||||||||||
| 2 | ||||||||||||||
| 3 | DRIVER | NUMBER | NUMBER 2 | DATE | NUMBER3 | CUS | NUMBER 4 | KG | MONEY | NUMBER5 | NUBER6 | NUMBER7 | ||
| 4 | DRIVER1 | 31517 | MERGE1 | 44805 | 281 | A | 2T2 | 2165.8 | 1 | 50000 | 500000 | 550000 | ||
| 5 | DRIVER1 | 31517 | MERGE1 | 44805 | 282 | A | 2T2 | 481.1 | 1 | 50000 | 500000 | 550000 | ||
| 6 | DRIVER1 | 31517 | 44820 | 127 | A | 2T1 | 1980 | 1 | 0 | 1200000 | 1200000 | |||
| 7 | DRIVER4 | 86523 | MERGE2 | 44805 | 283 | A | 2T2 | 1511.7 | 1 | 50000 | 500000 | 550000 | ||
| 8 | DRIVER4 | 86523 | MERGE2 | 44805 | 284 | A | 2T2 | 537.8 | 1 | 50000 | 500000 | 550000 | ||
| 9 | DRIVER2 | 17050 | 44805 | 285 | A | 2T1 | 3763 | 1 | 0 | 1000000 | 1000000 | |||
| 10 | DRIVER3 | 13668 | 44805 | 286 | A | 5T1 | 5477.5 | 1 | 0 | 1600000 | 1600000 | |||
| 11 | DRIVER6 | 1918 | 44805 | 287 | A | 5T1 | 4799.7 | 1 | 0 | 1600000 | 1600000 | |||
| 12 | DRIVER2 | 17050 | 44805 | 288 | A | 2T1 | 3834.8 | 1 | 0 | 1000000 | 1000000 | |||
| 13 | DRIVER4 | 86523 | 44805 | 289 | A | 2T1 | 2192.9 | 1 | 0 | 1200000 | 1200000 | |||
| 14 | DRIVER7 | 9976 | 44805 | 290 | A | 5T1 | 5943.2 | 1 | 0 | 1600000 | 1600000 | |||
| 15 | DRIVER1 | 31517 | 44809 | 1 | A | 2T1 | 2039.5 | 1 | 0 | 1000000 | 1000000 | |||
| 16 | DRIVER4 | 86523 | 44809 | 2 | A | 2T1 | 2116.2 | 1 | 0 | 1000000 | 1000000 | |||
| 17 | DRIVER7 | 9976 | 44809 | 3 | A | 5T1 | 5397.6 | 1 | 0 | 1600000 | 1600000 | |||
| 18 | DRIVER3 | 13668 | 44809 | 4 | A | 5T1 | 6195.9 | 1 | 0 | 3400000 | 3400000 | |||
| 19 | DRIVER4 | 86523 | 44816 | 77 | A | 2T1 | 1867.8 | 1 | 0 | 1400000 | 1400000 | |||
| 20 | DRIVER1 | 31517 | 44809 | 5 | A | 2T1 | 2196.2 | 1 | 0 | 1000000 | 1000000 | |||
| 21 | DRIVER2 | 17050 | 44809 | 6 | A | 2T2 | 1196.6 | 1 | 50000 | 500000 | 550000 | |||
| 22 | DRIVER2 | 17050 | 44809 | 7 | A | 2T2 | 1407.6 | 1 | 50000 | 500000 | 550000 | |||
| 23 | DRIVER7 | 6509 | 44809 | 8 | A | 5T2 | 3146.6 | 1 | 50000 | 800000 | 850000 | |||
| 24 | DRIVER7 | 6509 | 44809 | 9 | A | 5T2 | 602.7 | 1 | 50000 | 800000 | 850000 | |||
| 25 | DRIVER5 | 34967 | 44821 | 132 | A | 2T2 | 1012 | 1 | 50000 | 700000 | 750000 | |||
| 26 | DRIVER4 | 86523 | 44809 | 10 | A | 2T1 | 3675.1 | 1 | 0 | 500000 | 500000 | |||
| 27 | DRIVER7 | 9976 | 44809 | 11 | A | 2T1 | 5580.2 | 1 | 0 | 0 | 0 | |||
| 28 | DRIVER2 | 17050 | 44820 | 118 | A | 2T2 | 455.9 | 1 | 50000 | 500000 | 550000 | |||
| 29 | ||||||||||||||
| 30 | ||||||||||||||
Sheet1 | ||||||||||||||
I NEED TO TURN TO THIS REPORT
| TEST.xlsx | ||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | G | H | I | J | K | L | |||
| 1 | ||||||||||||||
| 2 | ||||||||||||||
| 3 | DRIVER | NUMBER | NUMBER 2 | DATE | NUMBER3 | CUS | NUMBER 4 | KG | MONEY | NUMBER5 | NUBER6 | NUMBER7 | ||
| 4 | DRIVER1 | 31517 | MERGE1 | 44805 | 281 | A | 2T2 | 2165.8 | 1 | 50000 | 500000 | 1100000 | ||
| 5 | DRIVER1 | 31517 | MERGE1 | 44805 | 282 | A | 2T2 | 481.1 | 1 | 50000 | 500000 | |||
| 6 | DRIVER1 | 31517 | 44820 | 127 | A | 2T1 | 1980 | 1 | 0 | 1200000 | 1200000 | |||
| 7 | DRIVER1 | 31517 | 44809 | 1 | A | 2T1 | 2039.5 | 1 | 0 | 1000000 | 1000000 | |||
| 8 | DRIVER1 | 31517 | 44809 | 5 | A | 2T1 | 2196.2 | 1 | 0 | 1000000 | 1000000 | |||
| 9 | TOTAL DRIVER 1 | 43000000 | ||||||||||||
| 10 | DRIVER2 | 17050 | 44805 | 285 | A | 2T1 | 3763 | 1 | 0 | 1000000 | 1000000 | |||
| 11 | DRIVER2 | 17050 | 44805 | 288 | A | 2T1 | 3834.8 | 1 | 0 | 1000000 | 1000000 | |||
| 12 | DRIVER2 | 17050 | 44809 | 6 | A | 2T2 | 1196.6 | 1 | 50000 | 500000 | 550000 | |||
| 13 | DRIVER2 | 17050 | 44809 | 7 | A | 2T2 | 1407.6 | 1 | 50000 | 500000 | 550000 | |||
| 14 | DRIVER2 | 17050 | 44820 | 118 | A | 2T2 | 455.9 | 1 | 50000 | 500000 | 550000 | |||
| 15 | TOTAL DRIVER 2 | 3650000 | ||||||||||||
| 16 | DRIVER3 | 13668 | 44805 | 286 | A | 5T1 | 5477.5 | 1 | 0 | 1600000 | 1600000 | |||
| 17 | DRIVER3 | 13668 | 44809 | 4 | A | 5T1 | 6195.9 | 1 | 0 | 3400000 | 3400000 | |||
| 18 | TOTAL DRIVER 3 | 5000000 | ||||||||||||
| 19 | DRIVER4 | 86523 | MERGE2 | 44805 | 283 | A | 2T2 | 1511.7 | 1 | 50000 | 500000 | 110000 | ||
| 20 | DRIVER4 | 86523 | MERGE2 | 44805 | 284 | A | 2T2 | 537.8 | 1 | 50000 | 500000 | |||
| 21 | DRIVER4 | 86523 | 44805 | 289 | A | 2T1 | 2192.9 | 1 | 0 | 1200000 | 1200000 | |||
| 22 | DRIVER4 | 86523 | 44809 | 2 | A | 2T1 | 2116.2 | 1 | 0 | 1000000 | 1000000 | |||
| 23 | DRIVER4 | 86523 | 44816 | 77 | A | 2T1 | 1867.8 | 1 | 0 | 1400000 | 1400000 | |||
| 24 | DRIVER4 | 86523 | 44809 | 10 | A | 2T1 | 3675.1 | 1 | 0 | 500000 | 500000 | |||
| 25 | TOTAL DRIVER 4 | 52000000 | ||||||||||||
| 26 | DRIVER5 | 34967 | 44821 | 132 | A | 2T2 | 1012 | 1 | 50000 | 700000 | 52000000 | |||
| 27 | TOTAL DRIVER 5 | 43000000 | ||||||||||||
| 28 | DRIVER6 | 1918 | 44805 | 287 | A | 5T1 | 4799.7 | 1 | 0 | 1600000 | 43000000 | |||
| 29 | TOTAL DRIVER 6 | 43000000 | ||||||||||||
| 30 | DRIVER7 | 9976 | 44805 | 290 | A | 5T1 | 5943.2 | 1 | 0 | 1600000 | 1600000 | |||
| 31 | DRIVER7 | 9976 | 44809 | 3 | A | 5T1 | 5397.6 | 1 | 0 | 1600000 | 1600000 | |||
| 32 | DRIVER7 | 6509 | 44809 | 8 | A | 5T2 | 3146.6 | 1 | 50000 | 800000 | 850000 | |||
| 33 | DRIVER7 | 6509 | 44809 | 9 | A | 5T2 | 602.7 | 1 | 50000 | 800000 | 850000 | |||
| 34 | DRIVER7 | 9976 | 44809 | 11 | A | 2T1 | 5580.2 | 1 | 0 | 0 | 0 | |||
| 35 | TOTAL DRIVER 7 | 49000000 | ||||||||||||
| 36 | ||||||||||||||
Sheet2 | ||||||||||||||
STEPS:
1. FILTER COLUMN DRIVER ( COLUMN A) FROM A TO Z)
2. INSERT 1 TOTAL ROW FOR EACH DRIVER. COUNT THE TOTAL FOR THAT DRIVER IN COLUMN L (NUMBER7)
3.FIND IN COLUMN C IF SAME WORD , MERGE AND SUM AND CENTER IN COLUM L
I HAVE A LARGE NUMBER ROW DATA. SO PLEASE HELP. THIS REALLY HELP ME SAVE TIME LIKE AN HOUR . I AM APPRICIATE FOR THE HELP. THANK YOU
Last edited:
