Date List

  • Thread starter Thread starter JP
  • Start date Start date
J

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
 
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
 
Back
Top