+ Reply to Thread
Results 1 to 2 of 2

Find removed and added entries comparing two worksheets

  1. 09-05-2013, 05:14 AM #1
    wintheranders
    wintheranders is offline
    Registered User
    Join Date
    04-10-2013
    Location
    DK
    MS-Off Ver
    Excel 2010
    Posts
    29

    Find removed and added entries comparing two worksheets

    Hi there

    Hopefully you can help me out of this one.

    Each months I receive a worksheet containing a list of items and entities. There are often added and removed items and entities, and as the list is extremely long I need a proper formula that provide me the result of the added + removed entries. Preferably on the 3rd worksheet.

    I have tried using vlookup, counifs, if, or, etc. in different combinations......

    Thank you in advance - Always appreciated!

    /wintheranders
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 09-05-2013, 05:50 AM #2
    ramananhrm
    ramananhrm is offline
    Valued Forum Contributor
    Join Date
    09-15-2011
    Location
    Chennai, India
    MS-Off Ver
    Excel 2010
    Posts
    436

    Re: Find removed and added entries comparing two worksheets

    Please try this file.

    Hoping that i have understood the scenario.
    Attached Files Attached Files
    Please click 'Add reputation', if my answer helped you.
    Reply With QuoteRegister To Reply
  3. 09-05-2013, 06:53 AM #3
    wintheranders
    wintheranders is offline
    Registered User
    Join Date
    04-10-2013
    Location
    DK
    MS-Off Ver
    Excel 2010
    Posts
    29

    Re: Find removed and added entries comparing two worksheets

    You have understood the scenario of finding the one's removed(missing), but Im still missing to find the one's added?
    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)

Similar Threads

  1. Find Missing Entries when comparing two columns
    By HangMan in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 07-31-2013, 12:35 AM
  2. Comparison for monthly reports.... accounts added and removed
    By SpottedTApps in forum Excel General
    Replies: 1
    Last Post: 03-08-2012, 03:59 AM
  3. Comparing Columns Between Worksheets to Find a Value
    By jimmy_nora in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-19-2010, 07:42 AM
  4. [SOLVED] pivot chart colors- how to keep from changing when data elements are added/removed?
    By KR in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 07-12-2006, 01:40 PM
  5. 2 workbooks - how do I find duplicate entries by comparing the two
    By queen on in forum Excel General
    Replies: 2
    Last Post: 09-20-2005, 07:05 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1