List of matches

[Graham]

Is there a simple way for me to present on one page a
list of values from colum A that match a date value in
column C.

For example

A B
Dave 1/3/04
Bob 1/3/04
Jim 2/4/04
Colin 2/6/05
Eric 3/5/04
Jane 12/5/04
Laura 1/6/05
Mike 4/7/04

I would like on page two to show only the names that
match a ceratin criteria for example Today or This Week
or Next week.

I am also thinking appearing in drop down form may be
preferable.

Any help appreciated

 

[Peter]

-----Original Message-----
Is there a simple way for me to present on one page a
list of values from colum A that match a date value in
column C.

Graham

Try Data, Filter, Autofilter and see if this will suit.

To get more ideas on Filters try Debra Dalgliesh's site
contextures.com It includes lots of good ideas including
advanced filters and macros

Peter Atherton

(e-mail address removed)

 

[Bernie Deitrick]

Graham,

You can use filtering, though you would need to use the custom, where you
select dates greater than or equal to the start date, and less than or equal
to the end date of interest.

HTH,
Bernie
MS Excel MVP