+ Reply to Thread
Results 1 to 2 of 2

Lump data into batches and rank by date

  1. 01-21-2018, 04:51 PM #1
    Ocdawg
    Ocdawg is offline
    Registered User
    Join Date
    01-20-2018
    Location
    OC
    MS-Off Ver
    2007
    Posts
    14

    Lump data into batches and rank by date

    Greetings,

    I want to make a production schedule from the data I have from sales orders. I want to group skateboard models then using the quantity ordered for each, lump them into batches of 25 and ranked by earliest order date. Can this be done?

    Thanks!

    Ocdawg
    Reply With QuoteRegister To Reply
  2. 01-23-2018, 10:42 AM #2
    JeteMc
    JeteMc is offline
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,522

    Re: Lump data into batches and rank by date

    Hello Ocdawg and Welcome to Excel Forum.
    You'll need to provide the rational that will be used for grouping the skateboards and an example of how the batches will be lumped.
    Please upload a sample workbook directly to this site by clicking on the GO ADVANCED button below the Quick Reply window and then scrolling down to Manage Attachments to open the upload window.
    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
    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. Rank data and output data based on rank
    By thedrinkerparadox in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 08-08-2017, 12:28 PM
  2. Migrating Data from a Single Column to Multiple Columns in Batches of 35
    By Acid Ghost in forum Excel General
    Replies: 1
    Last Post: 05-21-2014, 01:41 PM
  3. i used this code to dowload data of single batchname(006) but i want multiple batches
    By baig123 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-12-2014, 03:25 AM
  4. [SOLVED] formula to calculate future value of a lump sum, compound interest returning a to date val
    By psydoc in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 08-16-2013, 11:20 PM
  5. Copy multiple batches of data using VBA
    By ormerods in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-07-2013, 10:41 AM
  6. [SOLVED] how to compute interest for a lump sum
    By autocoder in forum Excel General
    Replies: 0
    Last Post: 01-12-2006, 04:15 PM
  7. Rank items, select one start date, have remaining dates follow based on rank
    By rob normerica in forum Excel General
    Replies: 1
    Last Post: 08-15-2005, 05:05 PM

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