+ Reply to Thread
Results 1 to 3 of 3

Stock Take input statistics

Hybrid View

  1. #1
    Forum Contributor
    Join Date
    01-04-2014
    Location
    East Africa
    MS-Off Ver
    MS OFFICE 2013 PRO PLUS
    Posts
    3,705

    Stock Take input statistics

    I have explain in the attached file

    I am trying to find how much each input person took per sheet

    And I am trying to count how many lines of input we need an hour
    Attached Files Attached Files
    Last edited by makinmomb; 10-17-2014 at 11:46 AM.

  2. #2
    Forum Expert Vikas_Gautam's Avatar
    Join Date
    06-04-2013
    Location
    Ludhiana,Punjab, India
    MS-Off Ver
    Excel 2013
    Posts
    1,850

    Re: Stock Take input statistics

    Hi,
    Check the attached file...
    Attached Files Attached Files
    Regards,
    Vikas Gautam
    Excel-buzz.blogspot.com

    Excel is not a matter of Experience, its a matter of Application.

    Say Thanks, Click * Add Reputation

  3. #3
    Forum Contributor
    Join Date
    01-04-2014
    Location
    East Africa
    MS-Off Ver
    MS OFFICE 2013 PRO PLUS
    Posts
    3,705

    Re: Stock Take input statistics

    Super

    Only the count of sheet is wrong , the max lines a sheet can have is 16

    I think you have not taken into consideration the branch , sheet 020 can
    with with more than branch , I am looking into per branch case so that I
    can determine who is the fastest input person whom will give over time for
    added hours

+ 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. VBA Code to pull Stock Balance Sheet Data from a Stock Symbol in a cell
    By akash1229 in forum Excel Programming / VBA / Macros
    Replies: 22
    Last Post: 02-27-2015, 04:37 PM
  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. Replies: 4
    Last Post: 01-29-2013, 02:26 AM
  4. Replies: 0
    Last Post: 10-28-2012, 07:22 AM
  5. Replies: 0
    Last Post: 09-25-2012, 09:39 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