Results 1 to 5 of 5

Evenly distribute records over months & Year by their review dates

Threaded View

qadeerume Evenly distribute records... 01-24-2017, 06:43 AM
avk Re: Evenly distribute records... 01-24-2017, 08:17 AM
qadeerume Re: Evenly distribute records... 01-25-2017, 12:50 AM
avk Re: Evenly distribute records... 01-25-2017, 08:01 AM
qadeerume Re: Evenly distribute records... 01-26-2017, 02:19 AM
  1. #1
    Registered User
    Join Date
    12-26-2016
    Location
    SA, KSA
    MS-Off Ver
    2010, 2013, 2016, 2019
    Posts
    44

    Question Evenly distribute records over months & Year by their review dates

    Hi,


    I want to distribute 550+ documents over month for the 3 years as the review cycle is triennial, based on their review dates limited to 20 documents per month.
    e.g.
    Let’s say, there is a document whose Review Date is falling in JAN, 2017 so it counts to 1, and there are around 17 documents their review dates are falling in Feb, 2017 so it counts to 17, and around 11 documents their review dates are falling in Mar, 2017 so it counts to 11.

    I’ve to send 20 documents for JAN, 2017. So what I want is to take all 17 from Feb, 2017 and 2 from March, 2017… which counts to 20 in total. How to achieve this condition in unsorted data?

    Appreciate your time. Thanks!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Evenly distribute a number across several cells
    By gbursson in forum Excel General
    Replies: 2
    Last Post: 02-18-2015, 05:51 AM
  2. [SOLVED] Distribute Tasks Evenly
    By karthikcoep in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-12-2015, 05:48 AM
  3. Distribute Data Evenly
    By sohlican in forum Excel General
    Replies: 13
    Last Post: 09-19-2014, 07:37 PM
  4. Distribute variables evenly
    By Jovanator in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-18-2014, 12:15 PM
  5. Distribute Duration Evenly Amongst Tasks
    By mycon73 in forum Excel General
    Replies: 5
    Last Post: 09-10-2013, 11:21 AM
  6. Evenly distribute numbers
    By captain118 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-05-2013, 01:27 AM
  7. Evenly Amortise $ Value over Financial Year Months??
    By PERE in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-28-2013, 08:53 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