Results 1 to 17 of 17

calculating file intervals from 300 to 300

Threaded View

  1. #1
    Forum Contributor
    Join Date
    02-12-2013
    Location
    Brussel
    MS-Off Ver
    Excel 2013
    Posts
    134

    calculating file intervals from 300 to 300

    Hello experts!

    Here is a difficult one!

    I have a column O for inserting the number of document files that is registered in my workbook (ex: 3 files).
    In column P a have a formula that calculates the interval between files (ex: from 1 to 3), which is:
    =IF(OR(Q2>Q1;Q1="Folder's number");"1-"&O2;SUBTOTAL(9;O$2:INDIRECT("M"&ROW()-1))+1&"-"&SUBTOTAL(9;O$2:O2))
    In column Q I have a formula that calculates Folder's successively number if the files rich the maximum of 300 (ex: volum 1 for the first interval from 1 to 300, volum 2 for the next interval of 1 to 300, and so on):
    =IF(P1="1-"&O1;Q1;IF(SUBTOTAL(9;O$2:O2)<=300;1;Q1+1))
    The problem is that the formulas work only for the first interval. When the files gets to first 300 and is needed to recycle the hole process for the next interval of 300 files, which should be in volum 2, and so on.

    I've attached the workbook.

    Any ideas how can be solved?
    Is there a formula for this, or is necessary a VBA code?

    Thank you so much!
    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. Calculating quantiies from irregular intervals to regular intervals
    By abhi1421 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 05-15-2014, 06:34 AM
  2. Calculating Time Intervals
    By ExceltoLead in forum Excel General
    Replies: 1
    Last Post: 03-19-2011, 09:14 AM
  3. Calculating Overtime between intervals
    By roddie in forum Excel General
    Replies: 2
    Last Post: 01-29-2010, 07:42 AM
  4. Calculating Time Intervals
    By JustMe602 in forum Excel General
    Replies: 4
    Last Post: 05-23-2007, 07:55 PM
  5. calculating date intervals
    By jer in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 01-13-2006, 08:15 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