+ Reply to Thread
Results 1 to 2 of 2

Easy way to compare lists on different sheets???

  1. #1
    Registered User
    Join Date
    05-25-2016
    Location
    Hollywood, CA
    MS-Off Ver
    2016
    Posts
    79

    Easy way to compare lists on different sheets???

    I run across this problem all the time, but have never come up with a quick way to compare similar lists on 2 (or more) different worksheets. On the attached, List2 has 3 more rows (exported records) than List1. I know there's gotta be a slick way to have the rows that are unique to each worksheet show up, maybe using conditional formatting? Any advice/tips would be appreciated...
    Attached Files Attached Files

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,604

    Re: Easy way to compare lists on different sheets???

    You could put this formula in L1 of List2:

    =COUNTIF(List1!B:B,B1)

    then copy down to L58. If any cells in column L show zero, then that record is missing. The advantage of this method is that it will show duplicates - if a cell shows a 2 or larger, then that cell is duplicated on the other sheet (Joe Quintana).

    You can put a similar formula in L1 of List1, i.e.:

    =COUNTIF(List2!B:B,B1)

    and when this is copied down then as well as Joe Quintana showing that his name is duplicated on the other sheet, it can be seen that Lisa Segura is also duplicated on the other sheet (on rows 6 and 25).

    Thus, though one list has 55 and the other 58 entries, there are only two names on List2 which do not appear in List1.

    Hope this helps.

    Pete

+ 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. [SOLVED] Compare 2 lists in 2 spread sheets
    By Morleyb in forum Excel General
    Replies: 5
    Last Post: 07-27-2016, 06:55 AM
  2. [SOLVED] Looking for easy way to compare data over time - pivot?
    By svaeth in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 05-28-2015, 09:58 AM
  3. Compare two excels - Easy change between various documents
    By orjanmen in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 03-28-2014, 06:00 AM
  4. Replies: 0
    Last Post: 01-15-2013, 11:30 AM
  5. Compare 4 Lists
    By postelrich in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-27-2011, 05:35 PM
  6. Replies: 1
    Last Post: 11-03-2009, 11:41 AM
  7. [SOLVED] Compare two lists
    By ClaireView in forum Excel General
    Replies: 6
    Last Post: 01-09-2006, 05:10 PM

Tags for this Thread

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