+ Reply to Thread
Results 1 to 4 of 4

inventory formular

  1. 01-06-2013, 06:22 AM #1
    jayvheen
    jayvheen is offline
    Registered User
    Join Date
    01-05-2013
    Location
    rose hill, mauritius
    MS-Off Ver
    Excel 2003
    Posts
    1

    inventory formular

    untitled.JPG

    DATE ITEM IN AND OUT
    01-Jan-13 aa1 10
    02-Jan-13 bb2 5
    03-Jan-13 cc3 5
    04-Jan-13 aa1 -10
    05-Jan-13 aa1 30

    I dont know what formular to use to get the above results.

    ITEM BALANCE
    aa1 30
    bb2 5
    cc3 5

    Please Help!!!!!
    Thanks....
    Last edited by jayvheen; 01-06-2013 at 06:32 AM.
    Reply With QuoteRegister To Reply
  2. 01-06-2013, 06:59 AM #2
    TMS
    TMS is online now
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    48,943

    Re: inventory formular

    SUMIF or use a Pivot Table


    Regards, TMS
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke

    Reply With QuoteRegister To Reply
  3. 01-12-2013, 02:50 AM #3
    mahaveersomani
    mahaveersomani is offline
    Valued Forum Contributor
    Join Date
    09-04-2012
    Location
    india
    MS-Off Ver
    Excel 2007
    Posts
    463

    Re: inventory formular

    use the attached inventory files
    and enjoy dear

    and i m giving you one alternate too with the stock.....file
    check both attached files let me know if there are useful to you.

    Regards
    CA Mahaveer Somani
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  4. 01-12-2013, 05:01 AM #4
    Ghozi Alkatiri
    Ghozi Alkatiri is offline
    Valued Forum Contributor
    Join Date
    10-29-2012
    Location
    Mojokerto,Indonesia
    MS-Off Ver
    Excel 2007
    Posts
    554

    Re: inventory formular

    see this attahced
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1