Advanced Filter Help - I DARE YOU TO SOLVE THIS ONE!

joegio25

New Member
Joined
Sep 9, 2011
Messages
11
Hi guys and girls, sorry for the re-post but I just figured out how to share my file on Windows SkyDrive.

https://skydrive.live.com/redir.aspx?cid=4cdbd283ac4cd6f6&resid=4CDBD283AC4CD6F6!102

In the attachment you will find a list of products named "list." The first column is the product number i.e. 111.32 The following 9 columns are SKU numbers. To the right of the list is a section titled "criteria." This is the criteria of which I am using to run the advanced filter on the product list. Below the criteria section, is the section to where I would like the advanced filter to copy the results to. Sounds easy but as you can see in the criteria section, there are multiple product numbers that match (111.32), BUT have different sets of SKU #'s. When excel goes to filter the table, it is only finding the one match for each column, and copying to the section below. As you see in the results table.

It is grouping similar strings and grouping them as one. I DON'T want it to group.

As you can see in the "criteria" section, there are 4 sets of critera (each outlined in a different color) that form the "criteria" section. So, there should be 4 sets of SKU #'s in each of the columns in the "copy to" section. BUT THERE IS NOT! Again, it is grouping the like items.

Is this achievable? I would like to stay away from VBA, being the novice I am. But, if that is how I must do it, than I have no choice.

Thanks everyone!:)
 

Excel Facts

What is the shortcut key for Format Selection?
Ctrl+1 (the number one) will open the Format dialog for whatever is selected.
Make sure you Clear All from the results area first; I found I needed to do this.
 
Upvote 0
I got this. Is it right? (25 result rows):
Excel Workbook
TUVWXYZAAABACADAEAFAGAHAIAJAK
41COPY TO
42Productdigit #1digit #2SKU #1SKU #2SKU #3SKU #4SKU #5SKU #6SKU #7VendorCategoryCategory #ItemPart #QtyUOMIssue to WC no.
43111.32111.32.3XXXXXXXXTurnilsR8 Clutch3R8: 1 1/4" Clutch white 200/bxR8C03W1eaWC-40
44111.32X111.32.2xXXXXXXTurnilsR16 Clutch4R16: 1 1/2" Clutch black 200/bxR16C53BK1eaWC-40
45111.32XX111.32.2XXXXXXTurnilsTube51 1/2" Alum tube w/tape x 16' 8/bxRTEA4T1688ftWC-10
46111.32XXx111.32.1XXXXXTurnilsAdapter52" Adapter vanilla 50/bxRA2V1eaWC-40
47111.32XXxX111.32.7XXXXTurnilsStandard Bracket5380 Univ.bkt. 2" prog. For R8 black 100/bxRB380BK1prWC-40
48111.32XXxX111.32.8XXXXTurnilsStandard Bracket5560 Univ. bkt.1 1/2" for R16 nickel 100/bxRB5601prWC-40
49111.32XXxXX111.32.1XXXTurnilsIdle End1 1/4" End plug vanilla 200/bxREP031eaWC-40
50111.32XXxXXX111.32.9XXTurnilsCord LoopLoop Cord D30 3' - White 20/bgRDC03W108ftWC-40
51111.32XXxXXX111.32.10XXTurnilsCord LoopLoop Cord D30 4' - White 20/bgRDC04W108ftWC-40
52111.32XXxXXXX111.32.2XTurnilsBottom BarBottom rod black 16' 192'/bxRC44496888ftWC-10
53111.32XXxXXXX111.32.2XTurnilsBottom BarSmall round profile 16' 1600'/bxRC44508588ftWC-10
54111.32XXxXXXX111.32.2XTurnilsBottom BarLarge round profile 16' 1600'/bxRC44508688ftWC-10
55111.32XXxXXXX111.32.2XTurnilsBottom BarTriangular profile 16' 1600'/bxRC44508788ftWC-10
56111.32XXxXXXX111.32.2XTurnilsBottom BarBottom rod end cap, clear 100/bxRC4430088ftWC-40
57111.32XXxXXXXX111.32.1SheerweaveFabricSheerweave 4000SW4000
58111.32XXxXXXXX111.32.2SheerweaveFabricSheerweave 4400SW4400
59111.32XXxXXXXX111.32.3SheerweaveFabricSheerweave 5000SW5000
60111.11111.11.1XXXxxxxTurnilsR8 Clutch1R8: 1 1/4" Clutch vanilla 200/bxR8C031eaWC-40
61111.11X111.11.1xXXXXXTurnilsR16 Clutch3R16: 1 1/2" Clutch vanilla 200/bxR16C531eaWC-40
62111.11X111.11.10xXXXXXTurnilsGalaxy Clutch5G400 Black without hooks 25/bxRGAL400BK1eaWC-40
63111.11XX111.11.2XXXXXTurnilsTube51 1/2" Alum tube w/tape x 16' 8/bxRTEA4T1688ftWC-10
64111.11XXx111.11.1XXXXTurnilsAdapter52" Adapter vanilla 50/bxRA2V1eaWC-40
65111.11XXxX111.11.8XXXTurnilsStandard Bracket5560 Univ. bkt.1 1/2" for R16 nickel 100/bxRB5601prWC-40
66111.11XXxXX111.11.1XXTurnilsIdle End1 1/4" End plug vanilla 200/bxREP031eaWC-40
67111.11XXxXXX111.11.10XTurnilsCord LoopLoop Cord D30 4' - White 20/bgRDC04W108ftWC-40
Sheet
 
Upvote 0
Nope. Maybe, I'm not explaining it well enough. Where most people want to keep duplicates out of their filter results, I want to keep mine.

If you notice in the column labeled "digit #1" there is only one result for the SKU # "111.32.3" In the criteria section, there is clearly three instances in which this SKU # is listed.

I am wanting to see all three in the column "digit #1" It is just finding the first one.

Does that make sense?
 
Upvote 0
Nevermind, it still wouldn't be correct. I don't know if it's possible. I am basically trying to do multiple advanced filters and combine them together, all in one shot.
 
Upvote 0
Nevermind, it still wouldn't be correct. I don't know if it's possible. I am basically trying to do multiple advanced filters and combine them together, all in one shot.

Is this...

<TABLE style="WIDTH: 480pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=640><COLGROUP><COL style="WIDTH: 48pt" span=10 width=64><TBODY><TR style="HEIGHT: 27pt" height=36><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #ccc0da; WIDTH: 48pt; HEIGHT: 27pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl67 height=36 width=64>Product</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl68 width=64>digit #1</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl68 width=64>digit #2</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl68 width=64>SKU #1</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl68 width=64>SKU #2</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl68 width=64>SKU #3</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl68 width=64>SKU #4</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl68 width=64>SKU #5</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl68 width=64>SKU #6</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl68 width=64>SKU #7</TD></TR><TR style="HEIGHT: 14.4pt" height=19><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 14.4pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" height=19 align=right>111.32</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>111.32.3</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>X</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>X</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>X</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>X</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>X</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>X</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>X</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>X</TD></TR><TR style="HEIGHT: 14.4pt" height=19><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 14.4pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" height=19 align=right>111.32</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>X</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>111.32.2</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>x</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>X</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>X</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>X</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>X</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>X</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>X</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" height=20 align=right>111.32</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>X</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>X</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>111.32.2</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>X</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>X</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>X</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>X</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>X</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>X</TD></TR><TR style="HEIGHT: 14.4pt" height=19><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 14.4pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" height=19 align=right>111.32</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>X</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>X</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>x</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>111.32.1</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>X</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>X</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>X</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>X</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>X</TD></TR><TR style="HEIGHT: 14.4pt" height=19><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 14.4pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" height=19 align=right>111.32</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>X</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>X</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>x</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>X</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl70>111.32.7</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>X</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>X</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>X</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>X</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" height=20 align=right>111.32</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>X</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>X</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>x</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>X</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl70>111.32.8</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>X</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>X</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>X</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>X</TD></TR><TR style="HEIGHT: 14.4pt" height=19><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 14.4pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" height=19 align=right>111.32</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>X</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>X</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>x</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>X</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>X</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>111.32.1</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>X</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>X</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>X</TD></TR><TR style="HEIGHT: 14.4pt" height=19><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 14.4pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" height=19 align=right>111.32</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>X</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>X</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>x</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>X</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>X</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>X</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>111.32.9</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>X</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>X</TD></TR><TR style="HEIGHT: 14.4pt" height=19><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 14.4pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" height=19 align=right>111.32</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>X</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>X</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>x</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>X</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>X</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>X</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>111.32.10</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>X</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>X</TD></TR><TR style="HEIGHT: 14.4pt" height=19><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 14.4pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" height=19 align=right>111.32</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>X</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>X</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>x</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>X</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>X</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>X</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>X</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl71>111.32.2</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>X</TD></TR><TR style="HEIGHT: 14.4pt" height=19><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 14.4pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" height=19 align=right>111.32</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>X</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>X</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>x</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>X</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>X</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>X</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>X</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl71>111.32.2</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>X</TD></TR><TR style="HEIGHT: 14.4pt" height=19><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 14.4pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" height=19 align=right>111.32</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>X</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>X</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>x</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>X</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>X</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>X</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>X</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl71>111.32.2</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>X</TD></TR><TR style="HEIGHT: 14.4pt" height=19><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 14.4pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" height=19 align=right>111.32</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>X</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>X</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>x</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>X</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>X</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>X</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>X</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl71>111.32.2</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>X</TD></TR><TR style="HEIGHT: 14.4pt" height=19><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 14.4pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" height=19 align=right>111.32</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>X</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>X</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>x</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>X</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>X</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>X</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>X</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl71>111.32.2</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>X</TD></TR><TR style="HEIGHT: 14.4pt" height=19><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 14.4pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" height=19 align=right>111.32</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>X</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>X</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>x</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>X</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>X</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>X</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>X</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>X</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl71>111.32.1</TD></TR><TR style="HEIGHT: 14.4pt" height=19><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 14.4pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" height=19 align=right>111.32</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>X</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>X</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>x</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>X</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>X</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>X</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>X</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>X</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl71>111.32.2</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" height=20 align=right>111.32</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>X</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>X</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>x</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>X</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>X</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>X</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>X</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>X</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl71>111.32.3</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" height=20 align=right>111.11</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>111.11.1</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>X</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>X</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>X</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>x</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>x</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>x</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>x</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #00b0f0; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl72>X</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" height=20 align=right>111.11</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>X</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>111.11.1</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>x</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>X</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>X</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>X</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>X</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>X</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #00b0f0; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl72>X</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" height=20 align=right>111.11</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>X</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>X</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>111.11.2</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>X</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>X</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>X</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>X</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>X</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #00b0f0; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl72>X</TD></TR><TR style="HEIGHT: 14.4pt" height=19><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 14.4pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" height=19 align=right>111.11</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>X</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>X</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>x</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>111.11.1</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>X</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>X</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>X</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>X</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #00b0f0; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl72>X</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" height=20 align=right>111.11</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>X</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>X</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>x</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>X</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl70>111.11.8</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>X</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>X</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>X</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #00b0f0; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl72>X</TD></TR><TR style="HEIGHT: 14.4pt" height=19><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 14.4pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" height=19 align=right>111.11</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>X</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>X</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>x</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>X</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>X</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>111.11.1</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>X</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>X</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #00b0f0; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl72>X</TD></TR><TR style="HEIGHT: 14.4pt" height=19><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 14.4pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" height=19 align=right>111.11</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>X</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>X</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>x</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>X</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>X</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>X</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>111.11.10</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #e4dfec; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl69>X</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #00b0f0; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl72>X</TD></TR></TBODY></TABLE>

the result that you expect? Please disregard the blue colored cells and the fact that not all fields are displayed...
 
Upvote 0
Nope. Maybe, I'm not explaining it well enough. Where most people want to keep duplicates out of their filter results, I want to keep mine.

If you notice in the column labeled "digit #1" there is only one result for the SKU # "111.32.3" In the criteria section, there is clearly three instances in which this SKU # is listed.

I am wanting to see all three in the column "digit #1" It is just finding the first one.

Does that make sense?
You're saying that because the same line in the criteria section occurs x times, you expect to see the same line in the results x times - I think.
I don't think the advanced filter was designed to work that way (what would have to happen if you were to do this but filter the list in-place? It hides (filters out) those rows that don't apply, it would have to add rows).
I suspect the key word is Filter here, rather than Query.

One way to work around this is to put three advanced filter operations in one results block either manually or with vba:
Code:
With ActiveSheet
  .Range("A2:R422").AdvancedFilter Action:=xlFilterCopy, CriteriaRange:=.Range("T3:AC12"), CopyToRange:=.Range("T45"), Unique:=False
  Set StuffToDelete = .Range("Extract")
  Set NextDestn = .Range("Extract").Cells(1).End(xlDown).Offset(1)
  .Range("A2:R422").AdvancedFilter Action:=xlFilterCopy, CriteriaRange:=.Range("T13:AC22"), CopyToRange:=NextDestn, Unique:=False
  Set StuffToDelete = Union(.Range("Extract"), StuffToDelete)
  Set NextDestn = .Range("Extract").Cells(1).End(xlDown).Offset(1)
  .Range("A2:R422").AdvancedFilter Action:=xlFilterCopy, CriteriaRange:=.Range("T23:AC32"), CopyToRange:=NextDestn, Unique:=False
  Set StuffToDelete = Union(.Range("Extract"), StuffToDelete)
  Set NextDestn = .Range("Extract").Cells(1).End(xlDown).Offset(1)
  .Range("A2:R422").AdvancedFilter Action:=xlFilterCopy, CriteriaRange:=.Range("T33:AC42"), CopyToRange:=NextDestn, Unique:=False
  Set StuffToDelete = Union(.Range("Extract"), StuffToDelete)
End With
StuffToDelete.Delete xlShiftUp
The above needs improving to remove hard coded references and it could do with a loop and perhaps some sorting.

Possibly another way, if sql can get you what you want, is to query the table. A bit more involved to set up, but should be a lot more flexible.
 
Last edited:
Upvote 0

Forum statistics

Threads
1,215,046
Messages
6,122,852
Members
449,096
Latest member
Erald

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top