+ Reply to Thread
Results 1 to 2 of 2

Need assistance sorting a huge excel sheet (700K) rows!!!

Hybrid View

  1. 12-08-2014, 03:19 AM #1
    Kunna
    Kunna is offline
    Registered User
    Join Date
    10-24-2012
    Location
    Khartoum, Sudan
    MS-Off Ver
    Excel 2007
    Posts
    1

    Need assistance sorting a huge excel sheet (700K) rows!!!

    Hi,
    Well I have this file that I've been trying to sort unsuccessfully for some time, let me try to explain:

    1- The file has around 700,000 rows with multiple columns (Column A is the serial # column)
    2- I'm trying extract the serial numbers that fall within a specific range (e.g. between range of 355,000 to 360,000)
    3- I'm not very good at Pivot Tables (pretty good with formulas) but I got a couple of friends who are but there was something wrong and the sort always returned an error.

    Would really like to hear from you guys, y'all saved my butt twice before
    Reply With QuoteRegister To Reply
  2. 12-08-2014, 03:47 AM #2
    teylyn
    teylyn is offline
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,372

    Re: Need assistance sorting a huge excel sheet (700K) rows!!!

    Hello,

    you don't need a pivot table for that. You can turn on auto-filter (Data Ribbon > Autofilter button) or convert the table into Excel Table.

    To do that, select any cell and click Insert > Table. If the table has headers, tick the box.

    Now you can select any column header and use the filter and sort options in the context menu. Use Date Filters > Between and specify the desired date range.

    You can copy the filtered results and paste them into another sheet for further processing.

    cheers, teylyn
    Microsoft MVP
    http://www.teylyn.com
    Twitter: http://twitter.com/IngeborgNZ
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Totalling consecutive identical rows out of a huge sheet
    By spursfan323 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 02-26-2013, 06:53 AM
  2. Sorting huge list of dates
    By excel_newbert in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-15-2012, 10:20 AM
  3. Turning a huge text list into an organized excel sheet - rowls, columns, ect.
    By PatrickM in forum Excel General
    Replies: 8
    Last Post: 02-15-2012, 03:11 PM
  4. VBA help for 700k+ dataset
    By cjms85 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-07-2009, 12:33 PM
  5. [SOLVED] huge huge excel file... why?
    By Josh in forum Excel General
    Replies: 12
    Last Post: 02-09-2006, 06:00 PM

Tags for this Thread

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1