+ Reply to Thread
Results 1 to 2 of 2

subtraction with different way

  1. #1
    Forum Contributor
    Join Date
    05-08-2021
    Location
    ALQUDS
    MS-Off Ver
    2019
    Posts
    257

    subtraction with different way

    hi experts
    I have two sheets contains items should subtrct between two sheets and show the whole data in another sheet . usaully the items contain empty cells below th item . in this case in first sheet for ITEM AA-1000 start from the first cell contain this item and end to last empty cell before start a new item and so on for all the items with there is exception somtimes there is no empty cell under the item as in TT-100 . about the second sheet there are many items in COL B .in this case should subtract the first sheet based on COL B,C,D for each item in COLA from the second sheet based on COL E,F,G for each item in COL B . it should subtract for each ITEM in COL ITEM .
    the third sheet is expected result should be after fill for first and second sheet then should show the changes
    with considering if there are items in first sheet but not existed in second sheet then should also copy to third sheet below the item is relating of it with show mark "-" in col B,C as show in third sheet

    finally if there is not clear just inform me to add more details
    thanks in advance
    Attached Files Attached Files
    Last edited by Hasson; 08-28-2021 at 11:42 PM.

  2. #2
    Forum Contributor
    Join Date
    05-08-2021
    Location
    ALQUDS
    MS-Off Ver
    2019
    Posts
    257

    Re: subtraction with different way

    can any body help?

+ 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. Range Subtraction / Matrix Subtraction - Large data set
    By excelrabbit in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-20-2015, 07:07 AM
  2. Help regarding subtraction
    By Sabhay92 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-17-2013, 11:25 AM
  3. [SOLVED] Subtraction
    By bablubg in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 04-19-2012, 06:59 AM
  4. sum of subtraction every two row
    By vietdieu in forum Excel General
    Replies: 16
    Last Post: 01-22-2012, 05:07 PM
  5. Excel 2007 : Subtraction
    By GaidenFocus in forum Excel General
    Replies: 5
    Last Post: 11-17-2010, 02:21 PM
  6. subtraction
    By Kmac in forum Excel General
    Replies: 2
    Last Post: 04-06-2010, 05:53 PM
  7. Subtraction
    By georgei in forum Excel General
    Replies: 7
    Last Post: 11-04-2009, 10:52 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