Results 1 to 3 of 3

Inventory Formulas

Threaded View

  1. #1
    Registered User
    Join Date
    10-01-2017
    Location
    USA
    MS-Off Ver
    N/A
    Posts
    1

    Talking Inventory Formulas

    Hello everyone I just started to mess around with Excel and was wondering if it's possible to match items in 2 different columns and then subtract the QTY in 2 other columns to find a difference. I would like to match from Column A and Column C if they match then subtract from Column B and Column D. Thank you in advance for your help.

    COLUMN A...........COLUMN B............COLUMN C...............COLUMN D
    ITEM.....................QTY.....................ITEM...................... QTY
    AAA.......................5......................DDD.............................4
    BBB.......................1......................AAA.............................3
    DDD......................5......................BBB.............................1
    CCC.......................4......................CCC............................5
    EEE........................3......................EEE............................5


    NIK~
    Last edited by Nikkorasu86; 10-01-2017 at 04:30 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Audit Inventory Through COUNTIF Formulas and Macro
    By chrisbeaudet in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-03-2017, 11:34 AM
  2. Replies: 1
    Last Post: 07-29-2016, 06:07 PM
  3. Changing inventory in shopify using formulas!
    By seanfrank1994 in forum Excel General
    Replies: 1
    Last Post: 02-11-2016, 04:09 PM
  4. Guys please help me with aging inventory formulas
    By Blirey_Blirey in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-05-2014, 12:25 AM
  5. Macros and/or formulas needed for Inventory file.
    By foxguy in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-29-2012, 10:57 AM
  6. Replies: 6
    Last Post: 12-12-2010, 12:34 AM
  7. [SOLVED] inventory formulas
    By marsha in forum Excel General
    Replies: 2
    Last Post: 02-02-2006, 12:20 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