+ Reply to Thread
Results 1 to 3 of 3

Display differences between 2 sheets

  1. #1
    Registered User
    Join Date
    09-04-2020
    Location
    Lithuania
    MS-Off Ver
    16
    Posts
    2

    Display differences between 2 sheets

    Hello, i wanna compare 2 sheets by column in differences (by matching text in cell and quantity of equal cells). E.g. in sheet "1" i have "1" "2" "3" "a" "a" "c" (each symbol have another cell), sheet "2" have "b" "c" "a" "2" "3" "1". I wanna see result "a" when i compare sheet "1" vs "2", and result "a" "b" when compare sheet "2" vs "1". And formula, which i type, sometimes works, sometimes no...What is wrong?
    =IF('1'!A2<>"";IF(AND(SUMPRODUCT(--('1'!A2='2'!A$2:A$1500))<>0;SUMPRODUCT(--('1'!A2='2'!A$2:A$1500))=SUMPRODUCT(--('2'!A2='1'!A$2:A$1500)));"";'1'!A2);"")

  2. #2
    Registered User
    Join Date
    09-04-2020
    Location
    Lithuania
    MS-Off Ver
    16
    Posts
    2

    Re: Display differences between 2 sheets

    Attached file
    Attached Files Attached Files

  3. #3
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,540

    Re: Display differences between 2 sheets

    The closest that I see to what is described in post #1 is in column I of the 1 and 2 sheets, however the values in those columns do not match what is described in the post.
    I also feel that we will need a more detailed explanation of why "a" and "a" "b" are the expected results in order to help.
    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ 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. Duplicate Values in Ranking - How to Display Differences
    By ndesgeorges in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-02-2018, 12:21 AM
  2. Replies: 5
    Last Post: 11-30-2012, 01:33 PM
  3. [SOLVED] Compare data and display differences
    By jennifer5765 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 08-18-2012, 09:35 AM
  4. [SOLVED] find differences between 2 files and display each
    By melvyndb in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 05-14-2012, 06:41 AM
  5. How to compare data between 2 worksheets and display the differences
    By melvyndb in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-02-2012, 02:48 AM
  6. Compare columns & Display Differences
    By Pauldls in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-24-2005, 08:00 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