+ Reply to Thread
Results 1 to 6 of 6

Delivery Schedule Percentage

  1. #1
    Registered User
    Join Date
    06-26-2014
    Location
    Louisiana,USA
    MS-Off Ver
    Windows 8
    Posts
    3

    Delivery Schedule Percentage

    I'm trying to run a spreadsheet for Vendor Deliveries and got as far as promised delivery date and actual delivery date with a late or on time comment. Im trying to get a percentage from this data. Can someone help me with this!!? Please see the excel spreadsheet that i have uploaded. Delivery Schedule.xls

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,946

    Re: Delivery Schedule Percentage

    percent late:
    Please Login or Register  to view this content.
    Ben Van Johnson

  3. #3
    Registered User
    Join Date
    06-26-2014
    Location
    Louisiana,USA
    MS-Off Ver
    Windows 8
    Posts
    3

    Re: Delivery Schedule Percentage

    Not getting anything. Do i just enter that information into a blank cell below the column?

  4. #4
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,946

    Re: Delivery Schedule Percentage

    Formula in M3
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    06-26-2014
    Location
    Louisiana,USA
    MS-Off Ver
    Windows 8
    Posts
    3

    Re: Delivery Schedule Percentage

    I appreciate the help but im not much more than a beginner with excel and really dont quite understand what you just did. Is there an easier way? What i also want to do is filter just a single vendor from a period of time and get the same percentage like as if it was all the vendors.

  6. #6
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,946

    Re: Delivery Schedule Percentage

    comment deleted - mistake
    Last edited by protonLeah; 06-27-2014 at 11:54 PM.

+ 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. How can I create a shipment delivery schedule using MS Excel?
    By Winton88 in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 02-20-2014, 03:54 AM
  2. [SOLVED] Making a Delivery Schedule
    By Wictolia in forum Access Tables & Databases
    Replies: 6
    Last Post: 11-21-2013, 01:27 AM
  3. Delivery Schedule in Excel
    By Len351 in forum Excel General
    Replies: 14
    Last Post: 10-08-2012, 06:00 PM
  4. Goods in delivery schedule
    By moseleya in forum Access Tables & Databases
    Replies: 1
    Last Post: 03-13-2012, 02:01 PM
  5. Order Delivery Schedule
    By nescafe in forum Excel General
    Replies: 7
    Last Post: 03-22-2005, 10:34 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