Advance Filter not working

[shah shital]

hi

i have excel 2000 i find some problems in filter & advance
filter.

I have some data where i am useing advance filter but
advance filter is working some times & some times it done
work.

i find this problem at my office & home also.

It's work after few days again.

any help.

shital
..

 

[Dave Peterson]

I think you're going to have to post a few more details to get anyone to guess.

(Not a workbook, please.)

 

[Guest]

I have data lik

Sr. no., Date, name, bill no., item, rate, bill amoun
When I use advance filter with above data it works some times only
I have created criteria range in A1: B7 and data are A3:B135 when I put criteria in name it works some time and after some days data done not return any information about name and other data

shital shah

 

[Dave Peterson]

Just some general comments.

Make sure your list range include all your data. And verify that your dates are
really dates--not text.

 

[Debra Dalgleish]

If the criteria range is A1:B7, it overlaps the data range of A3:B135.
That could cause some problems.

 

[Dave Peterson]

Oooh. good eyes!

If the criteria range is A1:B7, it overlaps the data range of A3:B135.
That could cause some problems.