+ Reply to Thread
Results 1 to 2 of 2

Working with large sets of data

  1. #1
    Valued Forum Contributor
    Join Date
    03-17-2012
    Location
    Warsaw, Poland
    MS-Off Ver
    2007/2010
    Posts
    555

    Working with large sets of data

    Hi all,

    I'm about to get started on working with a dataset of ~80.000-100.000 rows and 12 columns.
    I have to decide on the approach first though.

    To make it simple, I have to summarize the data on various filters (lets say car types). How many were sold in which month etc.

    The car models are dynamic - one day I'll have 10 of them, another 50.

    Is a looping approach favorable in this situation? Or should I perhaps think about steering a pivottable with vba and copy paste the desired results?

    Or does anyone have better ideas?
    If you think that my answer was helpful, please click on the "Add to this user's Reputation" button.

  2. #2
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,767

    Re: Working with large sets of data

    Set the calculation to manual and use Autofilter instead of loop and use code to calculate the sheet/workbook whenever needed.


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

+ 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. Excel 2007 : Comparing Large Data Sets?
    By amgstar in forum Excel General
    Replies: 0
    Last Post: 11-01-2011, 04:53 PM
  2. Better chart labelers for large sets of data? (using TM currently)
    By woontime in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 08-04-2011, 02:25 AM
  3. interrogating large data sets
    By ruleworld in forum Excel General
    Replies: 1
    Last Post: 01-04-2011, 07:13 AM
  4. Tips for dealing with large data sets?
    By DyslexicHobo in forum Excel General
    Replies: 3
    Last Post: 03-02-2010, 02:06 PM
  5. how to save large data sets in excel
    By sheck in forum Excel General
    Replies: 1
    Last Post: 08-02-2005, 02:02 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