Problem w/Adv Filter criteria range
 

I'm hoping you can help me figure out what I've done wrong with the criteria
range.

It is:

Age=35; Age<=39; Annual=27,000

What returned was a single record of a person age 41 with an annual of 17,500.

The list range included over 290 records and I know there is at least one
that meets the above criteria.

Problem w/Adv Filter criteria range
 

It's difficult to guess how you set up this criteria range.

But if that's part of the problem, I'd read the notes at Debra Dalgleish's site:
http://contextures.com/xladvfilter02.html



Helen wrote:

I'm hoping you can help me figure out what I've done wrong with the criteria
range.

It is:

Age=35; Age<=39; Annual=27,000

What returned was a single record of a person age 41 with an annual of 17,500.

The list range included over 290 records and I know there is at least one
that meets the above criteria.

--

Dave Peterson