Results 1 to 5 of 5

copying dates based on sum of units

Threaded View

  1. #1
    Registered User
    Join Date
    12-22-2014
    Location
    Australia
    MS-Off Ver
    2016
    Posts
    89

    copying dates based on sum of units

    Hello experts,

    I am trying to solve below problem. Wondering if macro or a formula can help.

    Column A is the shipping date, Col B is the receiver ID, col C is the number of units shipped.

    Now if the number of units on a day is 4 or more then the date entered in result column must be same as in col A within the same row.

    If the number of units is less than 4 than check units in next row(date). if sum becomes 4 or more then enter the date corresponding to the row in the previous row.
    So until the sum of units becomes 4 or more keep checking next rows and then enter max date for those rows.
    Once the sum is 4 or more units go to the next row and check.

    max 4 rows will need to be looked because within 4 rows the sum should come to 4.

    Thanks
    Attached Files Attached Files
    Last edited by logisticsexcel; 02-11-2017 at 04:41 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Formula to determine number of units at each location and status of units
    By Klimer in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 08-18-2016, 10:01 AM
  2. Replies: 7
    Last Post: 04-30-2016, 03:20 AM
  3. Combining facts in different units in pivot-table
    By fredrikg in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 10-09-2014, 04:19 PM
  4. combining text from rows based upon current month dates
    By KK1234 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 05-26-2014, 03:42 PM
  5. Convert units based on cell format
    By Redrum555 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-19-2012, 03:11 AM
  6. [SOLVED] Calculate the Bonus units according to the quantity of the units bought (Help)
    By mo_naf in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-15-2012, 05:51 PM
  7. [SOLVED] How to determine the number of units based on given condition?
    By Eric in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-06-2006, 05:25 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