Combining Advanced Filter w/ PivotTable

[TSAConsultancy]

I am new to the MrExcel forum, so if this is covered someplace else, please forgive a newby.

My question has to do with trying to combine to Data functions in one table. In the data below there are duplicate records between the Customer No field and Item No field. I know this can be taken care of by running an Advanced Filter and selecting Unique Records. There are also variances in the Unit Price that I need to average. This can be done through a PivotTable. My issue is that I need to consolidate the unique records and average the Unit Price into a single line format (I need to match this data with add'l. fields in Filemaker Pro). Any advice or suggestions would be greatly appreciated!!

Customer No / Item No / Unit Price
20157 15090 $4.17
20157 15090 $4.13
20157 15090 $4.15
20157 15090 $4.12
20157 15090 $4.10
20157 20470 $8.00
20157 20570 $8.00
20157 20770 $10.00
20157 20770 $9.10
20157 20770 $10.20
20157 21782 $4.10
20157 22382 $0.95
20157 28982 $10.00
20157 30482 $4.10
20157 62291 $0.96
20157 62291 $0.93
20157 62291 $0.95
57331 33370 $19.95
57331 39770 $0.70
57331 50881 $3.35
57331 60791 $0.79
57331 60791 $0.81
57331 68671 $5.70
57331 05773 $2.56
57331 05773 $2.62
57331 05773 $2.70

 

[GaryWMn]

If I'm understanding you correctly, you would like to list every unique combination of the customer number and item number along with the related average unit price. You can use a PivotTable to accomplish the summary. Then you could set up another table to point to the PivotTable to generate your full list for combining with your other data.

It might look something like this.

<b>Excel 2003</b><table cellpadding="2.5px" rules="all" style=";background-color: #FFFFFF;border: 1px solid;border-collapse: collapse; border-color: #A6AAB6"><colgroup><col width="25px" style="background-color: #E0E0F0" /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /></colgroup><thead><tr style=" background-color: #E0E0F0;text-align: center;color: #161120"><th></th><th>A</th><th>B</th><th>C</th><th>D</th><th>E</th><th>F</th><th>G</th><th>H</th><th>I</th><th>J</th><th>K</th></tr></thead><tbody><tr ><td style="color: #161120;text-align: center;">1</td><td style="font-weight: bold;color: #FFFFFF;background-color: #0000FF;;">Original Data</td><td style="font-weight: bold;text-align: right;color: #FFFFFF;background-color: #0000FF;;"></td><td style="font-weight: bold;text-align: right;color: #FFFFFF;background-color: #0000FF;;"></td><td style="font-weight: bold;text-align: right;;"></td><td style="font-weight: bold;color: #FFFFFF;background-color: #800080;;">Pivot Table with Totals Hidden</td><td style="font-weight: bold;text-align: right;color: #FFFFFF;background-color: #800080;;"></td><td style="font-weight: bold;text-align: right;color: #FFFFFF;background-color: #800080;;"></td><td style="font-weight: bold;text-align: right;;"></td><td style="font-weight: bold;color: #FFFFFF;background-color: #008000;;">Linked Table</td><td style="font-weight: bold;text-align: right;color: #FFFFFF;background-color: #008000;;"></td><td style="font-weight: bold;text-align: right;color: #FFFFFF;background-color: #008000;;"></td></tr><tr ><td style="color: #161120;text-align: center;">2</td><td style="text-align: right;background-color: #99CCFF;;"></td><td style="text-align: right;background-color: #99CCFF;;"></td><td style="text-align: right;background-color: #99CCFF;;"></td><td style="text-align: right;;"></td><td style="text-align: right;border-bottom: 1px solid black;background-color: #CC99FF;;"></td><td style="text-align: right;border-bottom: 1px solid black;background-color: #CC99FF;;"></td><td style="text-align: right;border-bottom: 1px solid black;background-color: #CC99FF;;"></td><td style="text-align: right;;"></td><td style="text-align: right;background-color: #CCFFCC;;"></td><td style="text-align: right;background-color: #CCFFCC;;"></td><td style="text-align: right;background-color: #CCFFCC;;"></td></tr><tr ><td style="color: #161120;text-align: center;">3</td><td style="text-align: right;background-color: #99CCFF;;"></td><td style="text-align: right;background-color: #99CCFF;;"></td><td style="text-align: right;background-color: #99CCFF;;"></td><td style="text-align: right;border-right: 1px solid black;;"></td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #CC99FF;;">Average of  Unit Price</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #CC99FF;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #CC99FF;;"></td><td style="text-align: right;border-left: 1px solid black;;"></td><td style="color: #808080;background-color: #CCFFCC;;">=IF(E5=0,I4,E5)</td><td style="color: #808080;background-color: #CCFFCC;;">=F5</td><td style="color: #808080;background-color: #CCFFCC;;">=G5</td></tr><tr ><td style="color: #161120;text-align: center;">4</td><td style="font-weight: bold;background-color: #99CCFF;;">Customer No </td><td style="font-weight: bold;background-color: #99CCFF;;"> Item No </td><td style="font-weight: bold;background-color: #99CCFF;;"> Unit Price</td><td style="text-align: right;border-right: 1px solid black;;"></td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #CC99FF;;">Customer No </td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #CC99FF;;"> Item No </td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #CC99FF;;">Total</td><td style="text-align: right;border-left: 1px solid black;;"></td><td style="font-weight: bold;background-color: #CCFFCC;;">Customer No </td><td style="font-weight: bold;background-color: #CCFFCC;;"> Item No </td><td style="font-weight: bold;background-color: #CCFFCC;;">Total</td></tr><tr ><td style="color: #161120;text-align: center;">5</td><td style="text-align: right;background-color: #99CCFF;;">20157</td><td style="text-align: right;background-color: #99CCFF;;">15090</td><td style="text-align: right;background-color: #99CCFF;;"> 4.17 </td><td style="text-align: right;border-right: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #CC99FF;;">20157</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-left: 1px solid black;background-color: #CC99FF;;">15090</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-left: 1px solid black;background-color: #CC99FF;;">4.13 </td><td style="text-align: right;border-left: 1px solid black;;"></td><td style="text-align: right;background-color: #CCFFCC;;">20157</td><td style="text-align: right;background-color: #CCFFCC;;">15090</td><td style="text-align: right;background-color: #CCFFCC;;"> 4.13 </td></tr><tr ><td style="color: #161120;text-align: center;">6</td><td style="text-align: right;background-color: #99CCFF;;">20157</td><td style="text-align: right;background-color: #99CCFF;;">15090</td><td style="text-align: right;background-color: #99CCFF;;"> 4.13 </td><td style="text-align: right;border-right: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #CC99FF;;"></td><td style="text-align: right;border-right: 1px solid black;border-left: 1px solid black;background-color: #CC99FF;;">20470</td><td style="text-align: right;border-right: 1px solid black;border-left: 1px solid black;background-color: #CC99FF;;">8.00 </td><td style="text-align: right;border-left: 1px solid black;;"></td><td style="text-align: right;background-color: #CCFFCC;;">20157</td><td style="text-align: right;background-color: #CCFFCC;;">20470</td><td style="text-align: right;background-color: #CCFFCC;;"> 8.00 </td></tr><tr ><td style="color: #161120;text-align: center;">7</td><td style="text-align: right;background-color: #99CCFF;;">20157</td><td style="text-align: right;background-color: #99CCFF;;">15090</td><td style="text-align: right;background-color: #99CCFF;;"> 4.15 </td><td style="text-align: right;border-right: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #CC99FF;;"></td><td style="text-align: right;border-right: 1px solid black;border-left: 1px solid black;background-color: #CC99FF;;">20570</td><td style="text-align: right;border-right: 1px solid black;border-left: 1px solid black;background-color: #CC99FF;;">8.00 </td><td style="text-align: right;border-left: 1px solid black;;"></td><td style="text-align: right;background-color: #CCFFCC;;">20157</td><td style="text-align: right;background-color: #CCFFCC;;">20570</td><td style="text-align: right;background-color: #CCFFCC;;"> 8.00 </td></tr><tr ><td style="color: #161120;text-align: center;">8</td><td style="text-align: right;background-color: #99CCFF;;">20157</td><td style="text-align: right;background-color: #99CCFF;;">15090</td><td style="text-align: right;background-color: #99CCFF;;"> 4.12 </td><td style="text-align: right;border-right: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #CC99FF;;"></td><td style="text-align: right;border-right: 1px solid black;border-left: 1px solid black;background-color: #CC99FF;;">20770</td><td style="text-align: right;border-right: 1px solid black;border-left: 1px solid black;background-color: #CC99FF;;">9.77 </td><td style="text-align: right;border-left: 1px solid black;;"></td><td style="text-align: right;background-color: #CCFFCC;;">20157</td><td style="text-align: right;background-color: #CCFFCC;;">20770</td><td style="text-align: right;background-color: #CCFFCC;;"> 9.77 </td></tr><tr ><td style="color: #161120;text-align: center;">9</td><td style="text-align: right;background-color: #99CCFF;;">20157</td><td style="text-align: right;background-color: #99CCFF;;">15090</td><td style="text-align: right;background-color: #99CCFF;;"> 4.10 </td><td style="text-align: right;border-right: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #CC99FF;;"></td><td style="text-align: right;border-right: 1px solid black;border-left: 1px solid black;background-color: #CC99FF;;">21782</td><td style="text-align: right;border-right: 1px solid black;border-left: 1px solid black;background-color: #CC99FF;;">4.10 </td><td style="text-align: right;border-left: 1px solid black;;"></td><td style="text-align: right;background-color: #CCFFCC;;">20157</td><td style="text-align: right;background-color: #CCFFCC;;">21782</td><td style="text-align: right;background-color: #CCFFCC;;"> 4.10 </td></tr><tr ><td style="color: #161120;text-align: center;">10</td><td style="text-align: right;background-color: #99CCFF;;">20157</td><td style="text-align: right;background-color: #99CCFF;;">20470</td><td style="text-align: right;background-color: #99CCFF;;"> 8.00 </td><td style="text-align: right;border-right: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #CC99FF;;"></td><td style="text-align: right;border-right: 1px solid black;border-left: 1px solid black;background-color: #CC99FF;;">22382</td><td style="text-align: right;border-right: 1px solid black;border-left: 1px solid black;background-color: #CC99FF;;">0.95 </td><td style="text-align: right;border-left: 1px solid black;;"></td><td style="text-align: right;background-color: #CCFFCC;;">20157</td><td style="text-align: right;background-color: #CCFFCC;;">22382</td><td style="text-align: right;background-color: #CCFFCC;;"> 0.95 </td></tr><tr ><td style="color: #161120;text-align: center;">11</td><td style="text-align: right;background-color: #99CCFF;;">20157</td><td style="text-align: right;background-color: #99CCFF;;">20570</td><td style="text-align: right;background-color: #99CCFF;;"> 8.00 </td><td style="text-align: right;border-right: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #CC99FF;;"></td><td style="text-align: right;border-right: 1px solid black;border-left: 1px solid black;background-color: #CC99FF;;">28982</td><td style="text-align: right;border-right: 1px solid black;border-left: 1px solid black;background-color: #CC99FF;;">10.00 </td><td style="text-align: right;border-left: 1px solid black;;"></td><td style="text-align: right;background-color: #CCFFCC;;">20157</td><td style="text-align: right;background-color: #CCFFCC;;">28982</td><td style="text-align: right;background-color: #CCFFCC;;"> 10.00 </td></tr><tr ><td style="color: #161120;text-align: center;">12</td><td style="text-align: right;background-color: #99CCFF;;">20157</td><td style="text-align: right;background-color: #99CCFF;;">20770</td><td style="text-align: right;background-color: #99CCFF;;"> 10.00 </td><td style="text-align: right;border-right: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #CC99FF;;"></td><td style="text-align: right;border-right: 1px solid black;border-left: 1px solid black;background-color: #CC99FF;;">30482</td><td style="text-align: right;border-right: 1px solid black;border-left: 1px solid black;background-color: #CC99FF;;">4.10 </td><td style="text-align: right;border-left: 1px solid black;;"></td><td style="text-align: right;background-color: #CCFFCC;;">20157</td><td style="text-align: right;background-color: #CCFFCC;;">30482</td><td style="text-align: right;background-color: #CCFFCC;;"> 4.10 </td></tr><tr ><td style="color: #161120;text-align: center;">13</td><td style="text-align: right;background-color: #99CCFF;;">20157</td><td style="text-align: right;background-color: #99CCFF;;">20770</td><td style="text-align: right;background-color: #99CCFF;;"> 9.10 </td><td style="text-align: right;border-right: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #CC99FF;;"></td><td style="text-align: right;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #CC99FF;;">62291</td><td style="text-align: right;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #CC99FF;;">0.95 </td><td style="text-align: right;border-left: 1px solid black;;"></td><td style="text-align: right;background-color: #CCFFCC;;">20157</td><td style="text-align: right;background-color: #CCFFCC;;">62291</td><td style="text-align: right;background-color: #CCFFCC;;"> 0.95 </td></tr><tr ><td style="color: #161120;text-align: center;">14</td><td style="text-align: right;background-color: #99CCFF;;">20157</td><td style="text-align: right;background-color: #99CCFF;;">20770</td><td style="text-align: right;background-color: #99CCFF;;"> 10.20 </td><td style="text-align: right;border-right: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #CC99FF;;">57331</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-left: 1px solid black;background-color: #CC99FF;;">5773</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-left: 1px solid black;background-color: #CC99FF;;">2.63 </td><td style="text-align: right;border-left: 1px solid black;;"></td><td style="text-align: right;background-color: #CCFFCC;;">57331</td><td style="text-align: right;background-color: #CCFFCC;;">5773</td><td style="text-align: right;background-color: #CCFFCC;;"> 2.63 </td></tr><tr ><td style="color: #161120;text-align: center;">15</td><td style="text-align: right;background-color: #99CCFF;;">20157</td><td style="text-align: right;background-color: #99CCFF;;">21782</td><td style="text-align: right;background-color: #99CCFF;;"> 4.10 </td><td style="text-align: right;border-right: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #CC99FF;;"></td><td style="text-align: right;border-right: 1px solid black;border-left: 1px solid black;background-color: #CC99FF;;">33370</td><td style="text-align: right;border-right: 1px solid black;border-left: 1px solid black;background-color: #CC99FF;;">19.95 </td><td style="text-align: right;border-left: 1px solid black;;"></td><td style="text-align: right;background-color: #CCFFCC;;">57331</td><td style="text-align: right;background-color: #CCFFCC;;">33370</td><td style="text-align: right;background-color: #CCFFCC;;"> 19.95 </td></tr><tr ><td style="color: #161120;text-align: center;">16</td><td style="text-align: right;background-color: #99CCFF;;">20157</td><td style="text-align: right;background-color: #99CCFF;;">22382</td><td style="text-align: right;background-color: #99CCFF;;"> 0.95 </td><td style="text-align: right;border-right: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #CC99FF;;"></td><td style="text-align: right;border-right: 1px solid black;border-left: 1px solid black;background-color: #CC99FF;;">39770</td><td style="text-align: right;border-right: 1px solid black;border-left: 1px solid black;background-color: #CC99FF;;">0.70 </td><td style="text-align: right;border-left: 1px solid black;;"></td><td style="text-align: right;background-color: #CCFFCC;;">57331</td><td style="text-align: right;background-color: #CCFFCC;;">39770</td><td style="text-align: right;background-color: #CCFFCC;;"> 0.70 </td></tr><tr ><td style="color: #161120;text-align: center;">17</td><td style="text-align: right;background-color: #99CCFF;;">20157</td><td style="text-align: right;background-color: #99CCFF;;">28982</td><td style="text-align: right;background-color: #99CCFF;;"> 10.00 </td><td style="text-align: right;border-right: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #CC99FF;;"></td><td style="text-align: right;border-right: 1px solid black;border-left: 1px solid black;background-color: #CC99FF;;">50881</td><td style="text-align: right;border-right: 1px solid black;border-left: 1px solid black;background-color: #CC99FF;;">3.35 </td><td style="text-align: right;border-left: 1px solid black;;"></td><td style="text-align: right;background-color: #CCFFCC;;">57331</td><td style="text-align: right;background-color: #CCFFCC;;">50881</td><td style="text-align: right;background-color: #CCFFCC;;"> 3.35 </td></tr><tr ><td style="color: #161120;text-align: center;">18</td><td style="text-align: right;background-color: #99CCFF;;">20157</td><td style="text-align: right;background-color: #99CCFF;;">30482</td><td style="text-align: right;background-color: #99CCFF;;"> 4.10 </td><td style="text-align: right;border-right: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #CC99FF;;"></td><td style="text-align: right;border-right: 1px solid black;border-left: 1px solid black;background-color: #CC99FF;;">60791</td><td style="text-align: right;border-right: 1px solid black;border-left: 1px solid black;background-color: #CC99FF;;">0.80 </td><td style="text-align: right;border-left: 1px solid black;;"></td><td style="text-align: right;background-color: #CCFFCC;;">57331</td><td style="text-align: right;background-color: #CCFFCC;;">60791</td><td style="text-align: right;background-color: #CCFFCC;;"> 0.80 </td></tr><tr ><td style="color: #161120;text-align: center;">19</td><td style="text-align: right;background-color: #99CCFF;;">20157</td><td style="text-align: right;background-color: #99CCFF;;">62291</td><td style="text-align: right;background-color: #99CCFF;;"> 0.96 </td><td style="text-align: right;border-right: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #CC99FF;;"></td><td style="text-align: right;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #CC99FF;;">68671</td><td style="text-align: right;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #CC99FF;;">5.70 </td><td style="text-align: right;border-left: 1px solid black;;"></td><td style="text-align: right;background-color: #CCFFCC;;">57331</td><td style="text-align: right;background-color: #CCFFCC;;">68671</td><td style="text-align: right;background-color: #CCFFCC;;"> 5.70 </td></tr><tr ><td style="color: #161120;text-align: center;">20</td><td style="text-align: right;background-color: #99CCFF;;">20157</td><td style="text-align: right;background-color: #99CCFF;;">62291</td><td style="text-align: right;background-color: #99CCFF;;"> 0.93 </td><td style="text-align: right;;"></td><td style="text-align: right;border-top: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">21</td><td style="text-align: right;background-color: #99CCFF;;">20157</td><td style="text-align: right;background-color: #99CCFF;;">62291</td><td style="text-align: right;background-color: #99CCFF;;"> 0.95 </td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">22</td><td style="text-align: right;background-color: #99CCFF;;">57331</td><td style="text-align: right;background-color: #99CCFF;;">33370</td><td style="text-align: right;background-color: #99CCFF;;"> 19.95 </td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">23</td><td style="text-align: right;background-color: #99CCFF;;">57331</td><td style="text-align: right;background-color: #99CCFF;;">39770</td><td style="text-align: right;background-color: #99CCFF;;"> 0.70 </td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">24</td><td style="text-align: right;background-color: #99CCFF;;">57331</td><td style="text-align: right;background-color: #99CCFF;;">50881</td><td style="text-align: right;background-color: #99CCFF;;"> 3.35 </td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">25</td><td style="text-align: right;background-color: #99CCFF;;">57331</td><td style="text-align: right;background-color: #99CCFF;;">60791</td><td style="text-align: right;background-color: #99CCFF;;"> 0.79 </td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">26</td><td style="text-align: right;background-color: #99CCFF;;">57331</td><td style="text-align: right;background-color: #99CCFF;;">60791</td><td style="text-align: right;background-color: #99CCFF;;"> 0.81 </td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">27</td><td style="text-align: right;background-color: #99CCFF;;">57331</td><td style="text-align: right;background-color: #99CCFF;;">68671</td><td style="text-align: right;background-color: #99CCFF;;"> 5.70 </td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">28</td><td style="text-align: right;background-color: #99CCFF;;">57331</td><td style="text-align: right;background-color: #99CCFF;;">5773</td><td style="text-align: right;background-color: #99CCFF;;"> 2.56 </td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">29</td><td style="text-align: right;background-color: #99CCFF;;">57331</td><td style="text-align: right;background-color: #99CCFF;;">5773</td><td style="text-align: right;background-color: #99CCFF;;"> 2.62 </td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">30</td><td style="text-align: right;background-color: #99CCFF;;">57331</td><td style="text-align: right;background-color: #99CCFF;;">5773</td><td style="text-align: right;background-color: #99CCFF;;"> 2.70 </td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr></tbody></table><p style="width:3.6em;font-weight:bold;margin:0;padding:0.2em 0.6em 0.2em 0.5em;border: 1px solid #A6AAB6;border-top:none;text-align: center;background-color: #E0E0F0;color: #161120">Sheet1</p><br /><br />