 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / July 2006calendar question...
i set up a calendar with business days listed with a number "1" in the col to the right of the date. i am now trying to return business days only to a list in another sheet. i have done the following: - did a vlookup to pull back dates referenced "JULY". i am trying to search the calendar to pull bacl only the trading days. tried using index, but have to change row number for every cell. also cannot determine with index which dates to pull back...pulls theme all i am looking for the following result: 7/5/2006 7/6/2006 7/7/2006 7/10/2006 7/11/2006 7/12/2006 7/13/2006 7/14/2006 7/17/2006 7/18/2006 7/19/2006 7/20/2006 7/21/2006 7/24/2006 7/25/2006 7/26/2006 7/27/2006 7/28/2006 7/31/2006  Signaturebsurace Hi bsurace! I don't know if I understand what you want, but one possible solution is: Create name for the cell that has 7/5/2006 as Day1, 7/6/2006 Day2 and so on. On the other sheet simply put the formula = Day1, Day2 and so on. HTH Regards João Araújo > i set up a calendar with business days listed with a number "1" in the > col to the right of the date. i am now trying to return business days [quoted text clipped - 27 lines] > 7/28/2006 > 7/31/2006 bsurace Wrote: > i set up a calendar with business days listed with a number "1" in the > col to the right of the date. i am now trying to return business days [quoted text clipped - 27 lines] > 7/28/2006 > 7/31/2006 Make sure that both columns have headers, say Date (Column A) and WorkDay (Column B). Beside these two columns, put the following (this is the criteria for the advanced filter): C1: =B1 (The header for the WorkDay column) C2: 1 (The value that we want to be selected) Select A1:B50 (or however far down). Use the Advanced Filter. (Data->Filter->Advanced Filter...) Check the button beside Copy to another location Make sure that List Range is the $A$1:$B$50 (or whatever) Make the Criteria Range $C$1:$C$2 Make the Copy To Range whereever you want the data to go. (Say $D$1:$E$50) Hit OK. This should put the list you want in the location you want. Scott SignatureMaistrye |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.