Results 1 to 3 of 3

Excel 2010 Formula for Moving Data

Threaded View

  1. #1
    Registered User
    Join Date
    10-28-2014
    Location
    California, USA
    MS-Off Ver
    2010
    Posts
    16

    Question Excel 2010 Formula for Moving Data

    Template_1105.xlsx

    1. I need Help trying to move the Bulk orders of the cookies over to the 1k pack size, while keeping in mind, they have to match the code/date and add to the numbers in the same row's orders.
    ex:For the first bulk amount on 1/1/2014; it is showing 5 orders, so I need to move the 5 orders over to the 1k orders and add them together (5+15), the total combined amount going in the 1k order cell (=20). The Date(1/1/2014) has to match as well as the code, the materials don't matter in this part

    2. I also need to move the Ready Stages orders and add them to the processing stage's orders while keeping the same pack size/code/date all the same.
    ex: This next part is moving(adding) the "order"(order column) amounts of the "ready stages"(stage column) over to the "Processing stage"(stage column) (have to share same date/code type/Pack size)

    This is for a large amount of data that would take too long to do by hand. I would appreciate any help to make the process faster, Thanks!

    P.S The bulk orders are counted in thousands (1k) but still have no pack size.
    Last edited by blue84rain; 11-05-2014 at 07:46 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 11
    Last Post: 06-06-2014, 03:34 PM
  2. how to hide formula in formula box, view lookup result in formula box?
    By vengatvj in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-14-2013, 04:06 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1