Advanced Filter

[Kenneth Cohen]

I'm trying to use an advanced filter in Excel 2004. In the example below are
the three ranges: first the criteria range, second the data, third the
extract range. Originally this "test" worked correctly -- the only record
appearing in the extract range was no. 4, which matches "Miami" in the City
field. However, you can see the result that this is now producing. Can
anyone figure out what's gone wrong? The three ranges are defined
correctly, I've rechecked this several times.


Number Name Street City Province Country
Miami


Number Name Street City Province Country
1 Kenneth Cohen 65 Queen St. Toronto Ontario Canada
2 Mary Smith 85 Huron Street Detroit Michigan USA
3 Samantha Eggar 4444 Chelsea Road London Kent England
4 Sam Snead 14 Golfer's Heaven Miami Michigan USA
5 George Snow 180 Snowdon Way Snowball Ontario Canada


Number Name Street City Province Country
1 Kenneth Cohen 65 Queen St. Toronto Ontario Canada
2 Mary Smith 85 Huron Street Detroit Michigan USA
3 Samantha Eggar 4444 Chelsea Road London Kent England
4 Sam Snead 14 Golfer's Heaven Miami Michigan USA
5 George Snow 180 Snowdon Way Snowball Ontario Canada

 

[JE McGimpsey]

Can anyone figure out what's gone wrong? The three ranges are
defined correctly, I've rechecked this several times.

The only way I can replicate this is if the criteria range is incorrect
- say, only the header row, or more than 2 rows.