+ Reply to Thread
Results 1 to 8 of 8

Rolling stock calculation based on criteria

  1. #1
    Forum Contributor
    Join Date
    12-23-2013
    Location
    Hungary
    MS-Off Ver
    Excel 2013
    Posts
    331

    Rolling stock calculation based on criteria

    Hello,

    I would like to ask some help to calculate the "Stock To Be Prepared" value, it has rolling stock logic. Please, see the details and expected results in the attached file.
    Thank you for any help you can offer!
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    11-27-2007
    Location
    New Jersey, USA
    MS-Off Ver
    2013
    Posts
    1,669

    Re: Rolling stock calculation based on criteria

    Use this in F9 and copy down.

    HTML Code: 
    see attached file.
    Attached Files Attached Files
    1. Click on the * Add Reputation if you think this helped you
    2. Mark your thread as SOLVED when question is resolved

    Modytrane

  3. #3
    Forum Contributor
    Join Date
    12-23-2013
    Location
    Hungary
    MS-Off Ver
    Excel 2013
    Posts
    331

    Re: Rolling stock calculation based on criteria

    @modytrane

    Your solution is almost good for me but in cell F12 I would like to see 5 as result, do you have an idea for that?

  4. #4
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,079

    Re: Rolling stock calculation based on criteria

    Maybe
    Formula: copy to clipboard
    Please Login or Register  to view this content.

  5. #5
    Forum Expert
    Join Date
    11-27-2007
    Location
    New Jersey, USA
    MS-Off Ver
    2013
    Posts
    1,669

    Re: Rolling stock calculation based on criteria

    Try:

    HTML Code: 

  6. #6
    Forum Expert
    Join Date
    11-27-2007
    Location
    New Jersey, USA
    MS-Off Ver
    2013
    Posts
    1,669

    Re: Rolling stock calculation based on criteria

    That formula is for F13.
    Copy it up and down.

  7. #7
    Forum Contributor
    Join Date
    12-23-2013
    Location
    Hungary
    MS-Off Ver
    Excel 2013
    Posts
    331

    Re: Rolling stock calculation based on criteria

    Thank you very much the help!

  8. #8
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,079

    Re: Rolling stock calculation based on criteria

    You're welcome & thanks for the feedback
    Last edited by Fluff13; 06-25-2019 at 10:30 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Rolling Stock Count
    By Enigma1985 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-17-2017, 08:40 AM
  2. Identify the earliest expiry date on stock based on current stock levels
    By julie86xx in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-10-2013, 01:08 AM
  3. Rolling AFR calculation
    By Callingavan in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-15-2013, 05:57 AM
  4. Rolling sum of 12 months against each month based on two criteria
    By agupta5231 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-20-2013, 12:01 AM
  5. Calculation based on a criteria
    By hoosier5 in forum Excel General
    Replies: 3
    Last Post: 10-25-2011, 10:40 AM
  6. Criteria based calculation help.
    By rosarionyc in forum Excel General
    Replies: 18
    Last Post: 11-19-2010, 05:49 PM
  7. Performance of a stock over 20 day rolling periods
    By yamar in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-22-2009, 04:26 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