If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Date List
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 |
#2
|
|||
|
|||
Date List
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 -----Original Message----- 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 . |
Thread Tools | |
Display Modes | |
|
|