Results 1 to 4 of 4

How do I count number of values in row2 that doesn't exist in row1?

Threaded View

  1. #1
    Registered User
    Join Date
    08-15-2013
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    77

    Question How do I count number of values in row2 that doesn't exist in row1?

    I have two rows with values and blanks at the end (but I don't know how many blanks). For example,

    Row1: A C E G * * *
    Row2: H A C F I * * * *

    * is blank
    The values could be either text or numbers (but not both at the same time).
    Each individual row has unique values (no duplicate values in each row).

    1. I would like to know how many values there are in Row2 that doesn't exist in Row1, ignoring the blanks. In the example above, there are 3 values in Row2 that doesn't exist in Row1 (H, F, I).

    2. Alternatively, I would like to know how many of the values in Row1 also exist in Row2 (this is actually the final result that I need and it can easily be calculated from # of values in Row2 - result above = 5-3=2 ).

    Could someone propose a formula for this?
    TIA!
    Last edited by viking2; 08-26-2013 at 10:35 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Count number in row if another number exist
    By Reykjavik in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 07-04-2013, 04:16 PM
  2. Replies: 3
    Last Post: 09-22-2012, 01:11 AM
  3. Replies: 6
    Last Post: 08-22-2012, 07:53 AM
  4. VB Code is working for row1; how to apply to row2?
    By moike in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-17-2006, 02:50 PM
  5. Copy Worksheet to a new Workbook creating if it doesn't exist and add more Worksheets if it does exist
    By pete.bastin@btopenworld.com in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-18-2006, 01:10 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