Hey again, I have another question regarding the creation of a top 10 list. I want to create a list which will sum together the tickets if the bin number is the same, and then create a top 10 list of bins with the most tickets in them, displaying both the total ticket amount as well as the bin number.
I would also like to do this for the item number (the same item number I would like to sum the tickets together) but this would be a different list, and im sure the code would be similar to the above stated question.
Thanks!
here is some sample data
Excel 2002
I would also like to do this for the item number (the same item number I would like to sum the tickets together) but this would be a different list, and im sure the code would be similar to the above stated question.
Thanks!
here is some sample data
Excel Workbook | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
B | C | D | E | F | G | H | I | |||
3 | LOAD | |||||||||
4 | LOAD | TRIP | ZN | BIN | DOOR | DIV | ITM | |||
5 | DT | NO | NO | NO | NO | NO | NO | TICKETS | ||
6 | ---------- | ---- | --- | ------------ | ---- | ---- | ------- | ----------- | ||
7 | 7/19/2010 | 12 | AC2 | 766540140 | 57 | 609 | 49960 | 2 | ||
8 | 7/19/2010 | 12 | ALD | 763010006 | 57 | 609 | 43816 | 1 | ||
9 | 7/19/2010 | 12 | A09 | 765160056 | 57 | 609 | 10600 | 1 | ||
10 | 7/19/2010 | 12 | A09 | 765162003 | 57 | 609 | 13287 | 1 | ||
11 | 7/19/2010 | 12 | A09 | 781191606 | 57 | 649 | 88755 | 1 | ||
12 | 7/19/2010 | 12 | A09 | 781210000 | 57 | 609 | 13288 | 1 | ||
13 | 7/19/2010 | 12 | A09 | 781221858 | 57 | 642 | 80126 | 3 | ||
14 | 7/19/2010 | 12 | A09 | 781230800 | 57 | 609 | 49089 | 1 | ||
15 | 7/19/2010 | 12 | A09 | 781261854 | 57 | 642 | 32184 | 1 | ||
Query Info |