Hi Experts,
I want many different sets of information from the data sheet given below data for example I want to bring Mar Volume and Gross Sales for Customer 199 & 200 as shown below in the result sheet. Please share formula no VBA.
Similarly based on headings shown below another example, so formula should based on headings.
Data Sheet
Result.
Another example
I want many different sets of information from the data sheet given below data for example I want to bring Mar Volume and Gross Sales for Customer 199 & 200 as shown below in the result sheet. Please share formula no VBA.
Similarly based on headings shown below another example, so formula should based on headings.
Data Sheet
Year | Year | MM | Month | YTD No. | Customer # | Customer Name | Region Code | Region Name | Regional Manager | Area Code | Area Name | Area Manager | Item # | SKU | Grade | Segment | Volume | Gross sales |
2021 | A2021 | 01 | Jan | 90 | 1000298 | Customer 198 | ZRC5 | Region 5 | Regional Manager 5 | ZRAC21 | Area 21 | Area Manager 21 | PKG11010208 | ArfJet7 208 ltr | Arf | Segment 3 | 1,144 | 626,912 |
2021 | A2021 | 01 | Jan | 90 | 1000299 | Customer 199 | ZRC5 | Region 5 | Regional Manager 5 | ZRAC21 | Area 21 | Area Manager 21 | PKG11010208 | ArfJet7 208 ltr | Arf | Segment 3 | 986 | 540,328 |
2021 | A2021 | 01 | Jan | 90 | 1000300 | Customer 200 | ZRC5 | Region 5 | Regional Manager 5 | ZRAC21 | Area 21 | Area Manager 21 | PKG11010208 | ArfJet7 208 ltr | Arf | Segment 3 | 364 | 199,472 |
2021 | A2021 | 01 | Jan | 90 | 1000341 | Customer 241 | ZRC5 | Region 5 | Regional Manager 5 | ZRAC25 | Area 25 | Area Manager 25 | PKG11010208 | ArfJet7 208 ltr | Arf | Segment 3 | 211 | 115,628 |
2021 | A2021 | 01 | Jan | 90 | 1000342 | Customer 242 | ZRC5 | Region 5 | Regional Manager 5 | ZRAC25 | Area 25 | Area Manager 25 | PKG11010208 | ArfJet7 208 ltr | Arf | Segment 3 | 798 | 437,304 |
2021 | A2021 | 01 | Jan | 90 | 1000343 | Customer 243 | ZRC5 | Region 5 | Regional Manager 5 | ZRAC25 | Area 25 | Area Manager 25 | PKG11010208 | ArfJet7 208 ltr | Arf | Segment 1 | 388 | 212,624 |
2021 | A2021 | 01 | Jan | 90 | 1000344 | Customer 244 | ZRC5 | Region 5 | Regional Manager 5 | ZRAC25 | Area 25 | Area Manager 25 | PKG11010208 | ArfJet7 208 ltr | Arf | Segment 4 | 1,263 | 692,124 |
2021 | A2021 | 01 | Jan | 90 | 1000345 | Customer 245 | ZRC5 | Region 5 | Regional Manager 5 | ZRAC25 | Area 25 | Area Manager 25 | PKG11010208 | ArfJet7 208 ltr | Arf | Segment 2 | 852 | 466,896 |
2021 | A2021 | 01 | Jan | 90 | 1000346 | Customer 246 | ZRC5 | Region 5 | Regional Manager 5 | ZRAC25 | Area 25 | Area Manager 25 | PKG11010208 | ArfJet7 208 ltr | Arf | Segment 5 | 652 | 357,296 |
2021 | A2021 | 01 | Jan | 90 | 1000347 | Customer 247 | ZRC5 | Region 5 | Regional Manager 5 | ZRAC25 | Area 25 | Area Manager 25 | PKG11010208 | ArfJet7 208 ltr | Arf | Segment 4 | 333 | 182,484 |
2021 | A2021 | 01 | Jan | 90 | 1000348 | Customer 248 | ZRC5 | Region 5 | Regional Manager 5 | ZRAC25 | Area 25 | Area Manager 25 | PKG11010208 | ArfJet7 208 ltr | Arf | Segment 3 | 1,084 | 594,032 |
2021 | A2021 | 01 | Jan | 90 | 1000349 | Customer 249 | ZRC5 | Region 5 | Regional Manager 5 | ZRAC25 | Area 25 | Area Manager 25 | PKG11010208 | ArfJet7 208 ltr | Arf | Segment 4 | 1,082 | 592,936 |
2021 | A2021 | 01 | Jan | 90 | 1000350 | Customer 250 | ZRC5 | Region 5 | Regional Manager 5 | ZRAC25 | Area 25 | Area Manager 25 | PKG11010208 | ArfJet7 208 ltr | Arf | Segment 5 | 503 | 275,644 |
2021 | A2021 | 02 | Feb | 90 | 1000298 | Customer 198 | ZRC5 | Region 5 | Regional Manager 5 | ZRAC21 | Area 21 | Area Manager 21 | PKG11010208 | ArfJet7 208 ltr | Arf | Segment 3 | 2,704 | 1,498,016 |
2021 | A2021 | 02 | Feb | 90 | 1000299 | Customer 199 | ZRC5 | Region 5 | Regional Manager 5 | ZRAC21 | Area 21 | Area Manager 21 | PKG11010208 | ArfJet7 208 ltr | Arf | Segment 1 | 2,318 | 1,284,172 |
2021 | A2021 | 02 | Feb | 90 | 1000300 | Customer 200 | ZRC5 | Region 5 | Regional Manager 5 | ZRAC21 | Area 21 | Area Manager 21 | PKG11010208 | ArfJet7 208 ltr | Arf | Segment 1 | 894 | 495,276 |
2021 | A2021 | 02 | Feb | 90 | 1000341 | Customer 241 | ZRC5 | Region 5 | Regional Manager 5 | ZRAC25 | Area 25 | Area Manager 25 | PKG11010208 | ArfJet7 208 ltr | Arf | Segment 3 | 664 | 367,856 |
2021 | A2021 | 02 | Feb | 90 | 1000342 | Customer 242 | ZRC5 | Region 5 | Regional Manager 5 | ZRAC25 | Area 25 | Area Manager 25 | PKG11010208 | ArfJet7 208 ltr | Arf | Segment 1 | 2,750 | 1,523,500 |
2021 | A2021 | 02 | Feb | 90 | 1000343 | Customer 243 | ZRC5 | Region 5 | Regional Manager 5 | ZRAC25 | Area 25 | Area Manager 25 | PKG11010208 | ArfJet7 208 ltr | Arf | Segment 4 | 1,388 | 768,952 |
2021 | A2021 | 02 | Feb | 90 | 1000344 | Customer 244 | ZRC5 | Region 5 | Regional Manager 5 | ZRAC25 | Area 25 | Area Manager 25 | PKG11010208 | ArfJet7 208 ltr | Arf | Segment 2 | 4,308 | 2,386,632 |
2021 | A2021 | 02 | Feb | 90 | 1000345 | Customer 245 | ZRC5 | Region 5 | Regional Manager 5 | ZRAC25 | Area 25 | Area Manager 25 | PKG11010208 | ArfJet7 208 ltr | Arf | Segment 5 | 3,193 | 1,768,922 |
2021 | A2021 | 02 | Feb | 90 | 1000346 | Customer 246 | ZRC5 | Region 5 | Regional Manager 5 | ZRAC25 | Area 25 | Area Manager 25 | PKG11010208 | ArfJet7 208 ltr | Arf | Segment 3 | 2,623 | 1,453,142 |
2021 | A2021 | 02 | Feb | 90 | 1000347 | Customer 247 | ZRC5 | Region 5 | Regional Manager 5 | ZRAC25 | Area 25 | Area Manager 25 | PKG11010208 | ArfJet7 208 ltr | Arf | Segment 2 | 1,488 | 824,352 |
2021 | A2021 | 02 | Feb | 90 | 1000348 | Customer 248 | ZRC5 | Region 5 | Regional Manager 5 | ZRAC25 | Area 25 | Area Manager 25 | PKG11010208 | ArfJet7 208 ltr | Arf | Segment 1 | 4,543 | 2,516,822 |
2021 | A2021 | 02 | Feb | 90 | 1000349 | Customer 249 | ZRC5 | Region 5 | Regional Manager 5 | ZRAC25 | Area 25 | Area Manager 25 | PKG11010208 | ArfJet7 208 ltr | Arf | Segment 2 | 4,207 | 2,330,678 |
2021 | A2021 | 02 | Feb | 90 | 1000350 | Customer 250 | ZRC5 | Region 5 | Regional Manager 5 | ZRAC25 | Area 25 | Area Manager 25 | PKG11010208 | ArfJet7 208 ltr | Arf | Segment 3 | 1,895 | 1,049,830 |
2021 | A2021 | 03 | Mar | 90 | 1000298 | Customer 198 | ZRC5 | Region 5 | Regional Manager 5 | ZRAC21 | Area 21 | Area Manager 21 | PKG11010208 | ArfJet7 208 ltr | Arf | Segment 2 | 2,470 | 1,407,900 |
2021 | A2021 | 03 | Mar | 90 | 1000299 | Customer 199 | ZRC5 | Region 5 | Regional Manager 5 | ZRAC21 | Area 21 | Area Manager 21 | PKG11010208 | ArfJet7 208 ltr | Arf | Segment 5 | 2,144 | 1,222,080 |
2021 | A2021 | 03 | Mar | 90 | 1000300 | Customer 200 | ZRC5 | Region 5 | Regional Manager 5 | ZRAC21 | Area 21 | Area Manager 21 | PKG11010208 | ArfJet7 208 ltr | Arf | Segment 5 | 834 | 475,380 |
2021 | A2021 | 03 | Mar | 90 | 1000341 | Customer 241 | ZRC5 | Region 5 | Regional Manager 5 | ZRAC25 | Area 25 | Area Manager 25 | PKG11010208 | ArfJet7 208 ltr | Arf | Segment 2 | 401 | 228,570 |
2021 | A2021 | 03 | Mar | 90 | 1000342 | Customer 242 | ZRC5 | Region 5 | Regional Manager 5 | ZRAC25 | Area 25 | Area Manager 25 | PKG11010208 | ArfJet7 208 ltr | Arf | Segment 5 | 1,665 | 949,050 |
2021 | A2021 | 03 | Mar | 90 | 1000343 | Customer 243 | ZRC5 | Region 5 | Regional Manager 5 | ZRAC25 | Area 25 | Area Manager 25 | PKG11010208 | ArfJet7 208 ltr | Arf | Segment 3 | 837 | 477,090 |
Result.
Year | Month | Customer # | Customer Name | Area Name | Area Manager | Item # | SKU | Volume | Gross sales |
A2021 | Mar | 1000299 | Customer 199 | Area 21 | Area Manager 21 | PKG11010208 | ArfJet7 208 ltr | 2,144 | 1,222,080 |
A2021 | Mar | 1000300 | Customer 200 | Area 21 | Area Manager 21 | PKG11010208 | ArfJet7 208 ltr | 834 | 475,380 |
Another example
Year | Month | Customer # | Customer Name | Regional Manager | Area Code | Area Name | Area Manager | Grade | Segment | Volume | Gross sales |
A2021 | Mar | 1000298 | Customer 198 | Regional Manager 5 | ZRAC21 | Area 21 | Area Manager 21 | Arf | Segment 2 | 2,470 | 1,407,900 |
A2021 | Mar | 1000341 | Customer 241 | Regional Manager 5 | ZRAC25 | Area 25 | Area Manager 25 | Arf | Segment 2 | 401 | 228,570 |
A2021 | Mar | 1000346 | Customer 246 | Regional Manager 5 | ZRAC25 | Area 25 | Area Manager 25 | Arf | Segment 2 | 1,415 | 806,550 |
A2021 | Mar | 1000350 | Customer 250 | Regional Manager 5 | ZRAC25 | Area 25 | Area Manager 25 | Arf | Segment 2 | 993 | 566,010 |