I have a data set of 72,000+ rows. I want to filter that data based on two criteria. The problem is that I'm getting way more data that I'm supposed to.
Example:
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Employee Name
[/TD]
[TD]Employee ID
[/TD]
[TD]Hours
[/TD]
[TD]Job Code
[/TD]
[/TR]
[TR]
[TD]Clark Kent
[/TD]
[TD]123456789
[/TD]
[TD]8
[/TD]
[TD]YX890
[/TD]
[/TR]
[TR]
[TD]Hal Jordan
[/TD]
[TD]987654321
[/TD]
[TD]8.5
[/TD]
[TD]AB123
[/TD]
[/TR]
[TR]
[TD]Clark Kent
[/TD]
[TD]123456789
[/TD]
[TD]8
[/TD]
[TD]AB123
[/TD]
[/TR]
[TR]
[TD]Hal Jordan
[/TD]
[TD]987654321
[/TD]
[TD]12
[/TD]
[TD]AB123
[/TD]
[/TR]
[TR]
[TD]Bruce Wayne
[/TD]
[TD]456789123
[/TD]
[TD]8
[/TD]
[TD]RT456
[/TD]
[/TR]
[TR]
[TD]Bruce Wayne
[/TD]
[TD]456789123
[/TD]
[TD]5
[/TD]
[TD]AB123
[/TD]
[/TR]
[TR]
[TD]Bruce Wayne
[/TD]
[TD]456789123
[/TD]
[TD][/TD]
[TD]PO698
[/TD]
[/TR]
[TR]
[TD]Hal Jordan
[/TD]
[TD]987654321
[/TD]
[TD]6.25
[/TD]
[TD]RT456
[/TD]
[/TR]
[TR]
[TD]Clark Kent
[/TD]
[TD]123456789
[/TD]
[TD]8
[/TD]
[TD]YX890
[/TD]
[/TR]
</tbody>[/TABLE]
When I do the advanced filter, I'm selecting the source above and the criteria below. I then have the results copied to another location on the worksheet. Any advice for what's going wrong?
[TABLE="class: grid, width: 200"]
<tbody>[TR]
[TD]Employee ID
[/TD]
[TD]Job Code
[/TD]
[/TR]
[TR]
[TD]123456789
[/TD]
[TD]YX890
[/TD]
[/TR]
[TR]
[TD]987654321
[/TD]
[TD]PO698
[/TD]
[/TR]
[TR]
[TD]456789123
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]976413467
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]963258741
[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Example:
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Employee Name
[/TD]
[TD]Employee ID
[/TD]
[TD]Hours
[/TD]
[TD]Job Code
[/TD]
[/TR]
[TR]
[TD]Clark Kent
[/TD]
[TD]123456789
[/TD]
[TD]8
[/TD]
[TD]YX890
[/TD]
[/TR]
[TR]
[TD]Hal Jordan
[/TD]
[TD]987654321
[/TD]
[TD]8.5
[/TD]
[TD]AB123
[/TD]
[/TR]
[TR]
[TD]Clark Kent
[/TD]
[TD]123456789
[/TD]
[TD]8
[/TD]
[TD]AB123
[/TD]
[/TR]
[TR]
[TD]Hal Jordan
[/TD]
[TD]987654321
[/TD]
[TD]12
[/TD]
[TD]AB123
[/TD]
[/TR]
[TR]
[TD]Bruce Wayne
[/TD]
[TD]456789123
[/TD]
[TD]8
[/TD]
[TD]RT456
[/TD]
[/TR]
[TR]
[TD]Bruce Wayne
[/TD]
[TD]456789123
[/TD]
[TD]5
[/TD]
[TD]AB123
[/TD]
[/TR]
[TR]
[TD]Bruce Wayne
[/TD]
[TD]456789123
[/TD]
[TD][/TD]
[TD]PO698
[/TD]
[/TR]
[TR]
[TD]Hal Jordan
[/TD]
[TD]987654321
[/TD]
[TD]6.25
[/TD]
[TD]RT456
[/TD]
[/TR]
[TR]
[TD]Clark Kent
[/TD]
[TD]123456789
[/TD]
[TD]8
[/TD]
[TD]YX890
[/TD]
[/TR]
</tbody>[/TABLE]
When I do the advanced filter, I'm selecting the source above and the criteria below. I then have the results copied to another location on the worksheet. Any advice for what's going wrong?
[TABLE="class: grid, width: 200"]
<tbody>[TR]
[TD]Employee ID
[/TD]
[TD]Job Code
[/TD]
[/TR]
[TR]
[TD]123456789
[/TD]
[TD]YX890
[/TD]
[/TR]
[TR]
[TD]987654321
[/TD]
[TD]PO698
[/TD]
[/TR]
[TR]
[TD]456789123
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]976413467
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]963258741
[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]