Results 1 to 8 of 8

Sorting Large Data Set with Mixed Data

Threaded View

  1. #1
    Registered User
    Join Date
    12-31-2013
    Location
    Madison, WI
    MS-Off Ver
    Excel 2010
    Posts
    4

    Sorting Large Data Set with Mixed Data

    Does anyone have any good ideas on how to sort mixed data set? I've pulled a 70+ page that I will need to rerun about 60 times over the next few months. I'm hoping I can build a macro or template that will get me to the meat of the data faster.

    Cell A2 includes the customer number (6 digits) and A3-A7 includes their last several order numbers (8 digits), A8 includes the next customer number and A9-A20 includes their last several orders... Each customer will have a different number of orders. I'm hoping that I can create a new column that will associate the correct customer number with the correct order number. Then I can apply a number of if statements that will give me the data that should be reviewed by people.

    I appreciate any insights! Thank you.
    Attached Files Attached Files
    Last edited by reneeileen; 12-31-2013 at 12:25 PM. Reason: Include attachment

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Sorting large groups of data..
    By GroupStats in forum Excel General
    Replies: 3
    Last Post: 06-17-2013, 12:48 AM
  2. Sorting/Rearranging Large data set
    By flashyoyo in forum Excel General
    Replies: 1
    Last Post: 10-04-2012, 07:04 PM
  3. Sorting/Rearranging Large data set
    By flashyoyo in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 10-04-2012, 11:00 AM
  4. Sorting large data set
    By David1234 in forum Excel General
    Replies: 0
    Last Post: 09-27-2011, 06:31 PM
  5. Sorting problem with large data set
    By Infinity666 in forum Excel General
    Replies: 4
    Last Post: 10-20-2009, 11:56 AM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1