Date List

[JP]

I have a column of dates that looks something like this:

A
9/1/03
9/1/03
9/1/03
9/2/03
9/2/03
9/4/03
9/4/03
9/4/03

On a separate worksheet I am trying to add a list box that
will have one occurance of each day. I only need to pull
the day as a referance for another formula. Any help with
this is appreciated. Thanks.

JP Miller

 

[Manish Bajpai]

Hi JP,

Pl. keep the cursor on the heading of this column and then
click on top of tool bar "Data" , then select "Filter",
then, select "Advanced Filter". Then, select " Copy to
another location", fill the "list range", and also check
on "Unique records onlyh". Then, mention the location
where you want to copy the same in the box "Copy to".

Thanks & regards,

Manish