selecting date range / data range autofilter

H

hansiman

Is it possible to select rows based on a date range (say from
01-01-2005 to 31-12-2005) from column B:

A B C
id date value
1 01-01-2005 1
2 06-01-2005 1
3 08-02-2005 1
4 16-02-2005 1
5 03-03-2005 1
6 01-01-2004 1
7 06-05-2006 1
8 05-05-2005 1
9 06-06-2005 1
10 09-0 1
sum 10

Morten
 
C

CLR

Yes.............after clicking the AutoFilter arrow on your column of
choice, choose "Custom" and in the pop-up select the "greater than" and
"less than" options to give you your range of dates............

Vaya con Dios,
Chuck, CABGx3
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top