Autofilter based on to cells


Posted by Tim on June 12, 2001 4:51 PM

Does any1 know how i can filter a set of data depending on 2 data ranges -

1st being the start date and the second being the finish date



Posted by Barrie Davidson on June 12, 2001 5:36 PM

You can autofilter your data and specify a custom filter that is greater than (or equal to) the 1st date and less than (or equal to) the 2nd date. To autofilter select your data and then, from the menu bar, select Data|Filter|AutoFilter.

Regards,
Barrie