+ Reply to Thread
Results 1 to 9 of 9

Manage large data. Extract values only on specified dates

Hybrid View

  1. #1
    Forum Expert millz's Avatar
    Join Date
    08-14-2013
    Location
    Singapore
    MS-Off Ver
    Excel, Access 2016
    Posts
    1,694

    Re: Manage large data. Extract values only on specified dates

    I see, so you want the same date range over all years. If this is a one-time process, maybe you can just Date filter -> and use Between..., and repeat for each year?
    多么想要告诉你 我好喜欢你

  2. #2
    Forum Contributor
    Join Date
    05-09-2013
    Location
    london
    MS-Off Ver
    Excel 2016
    Posts
    107

    Re: Manage large data. Extract values only on specified dates

    Quote Originally Posted by millz View Post
    I see, so you want the same date range over all years. If this is a one-time process, maybe you can just Date filter -> and use Between..., and repeat for each year?
    Exactly! I want the same range over all years! The problem is that it is not a one-time process.. I have this kind of data for different station locations so I have like 30 Excel files with this kind of data, and some of these Excel files have data from 1950 to 2016.. Thats a lot of Winters... :\

    Regards

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Extract data from Large table
    By YasserKhalil in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 11-15-2014, 05:35 PM
  2. Trying to extract data from large spreadsheet
    By Caleesie in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 05-29-2014, 06:46 AM
  3. Manage a large amount of workbooks with CSV imported data
    By Chris_SS in forum Access Tables & Databases
    Replies: 4
    Last Post: 05-22-2014, 07:27 PM
  4. Extract Data From A Large Range Using VBA
    By Paul_SR in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-13-2014, 12:16 PM
  5. [SOLVED] How to manage a large nested if?
    By xdennis in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 01-25-2013, 10:42 PM
  6. Extract data in large dagtabase
    By firsttobecool in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-09-2012, 03:05 PM
  7. [SOLVED] How would you manage these dates?
    By JMF in forum Excel General
    Replies: 2
    Last Post: 03-28-2006, 10:30 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1