+ Reply to Thread
Results 1 to 3 of 3

Check to see if all values in row match any rows in a separate range

  1. #1
    Forum Contributor
    Join Date
    07-29-2013
    Location
    Oshawa
    MS-Off Ver
    Excel 2010
    Posts
    660

    Check to see if all values in row match any rows in a separate range

    Hi everyone,

    I have two worksheets: ws1 and ws2

    ws1.range("A1:Z1") all contain values

    ws2.range("A1:Z20") all contain values

    What I want to do is to check if ws2.range("A1:Z20") contains any rows that match all the values in ws1.range("A1:Z1"). So the match would be True if the values in the ws1 row match any of the rows in ws2.

    Any ideas?

    Thanks!!

  2. #2
    Forum Expert sweep's Avatar
    Join Date
    04-03-2007
    Location
    Great Sankey, Warrington, UK
    MS-Off Ver
    2003 / 2007 / 2010 / 2016
    Posts
    3,390

    Re: Check to see if all values in row match any rows in a separate range

    Hi,

    Does this help?

    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Rule 1: Never merge cells
    Rule 2: See rule 1

    "Tomorrow I'm going to be famous. All I need is a tennis racket and a hat".

  3. #3
    Forum Contributor
    Join Date
    07-29-2013
    Location
    Oshawa
    MS-Off Ver
    Excel 2010
    Posts
    660

    Re: Check to see if all values in row match any rows in a separate range

    Hi sweep,

    Thanks for your suggestions. However, this particular problem requires a VBA solution as its part of a larger macro.

+ 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] Check two lists on separate worksheets and copy only unique values
    By physicsgal in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 10-18-2017, 12:40 PM
  2. Replies: 1
    Last Post: 11-17-2014, 09:59 AM
  3. Macro to delete entire rows if cell values do not match list/named range.
    By swolfe2 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-17-2013, 02:13 PM
  4. Match LastRow to Rows Above to Check for Duplicates Rows
    By Hudas in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 03-13-2012, 08:10 AM
  5. Loop Array values Through a Range and Hide Rows if a Match
    By therzakid in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-29-2011, 01:04 PM
  6. Help! Need to move rows to separate worksheet if cell values match a value in range
    By nzamparo in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 07-25-2011, 12:20 AM
  7. Replies: 1
    Last Post: 07-14-2011, 01:57 PM

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