+ Reply to Thread
Results 1 to 2 of 2

Formula for counting of differences between columns

  1. #1
    Registered User
    Join Date
    11-12-2019
    Location
    Moravia
    MS-Off Ver
    2016
    Posts
    59

    Formula for counting of differences between columns

    Hello I need help with formula -

    I need to search and find differences between two areas - have Querry and input area - need to know how many records from Querry is missing in input - two conditions - needs to fit with xxx1 + Number 1 from Querry - certain row with xxx2 + Number 2 from input...number.....everytime there will be different number of rows, so I would like to have this formula working till row 1000 - you can see bordered cells...
    Attached Files Attached Files

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

    Re: Formula for counting of differences between columns

    I can only guess that you want to populate the Extract column (J) and that the formula produced results shown are not correct. I would be helpful if you could manually provide us with a few correct results so that we would know what our proposed formulas/code should yield.
    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. Replies: 12
    Last Post: 12-23-2017, 04:17 PM
  2. [SOLVED] Counting with Multiple Criteria - Months and Date Differences
    By kujoking7 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 08-14-2017, 04:58 PM
  3. [SOLVED] Formula to compare 2 columns for differences
    By Chris McGlothen in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-19-2016, 01:41 PM
  4. [SOLVED] Compare data in Columns A & B - Show differences in Columns C & D
    By syncguy in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-17-2015, 09:59 PM
  5. Replies: 0
    Last Post: 04-13-2015, 01:01 PM
  6. Counting Differences In A Column
    By Tom_LR in forum Excel General
    Replies: 1
    Last Post: 01-13-2009, 04:30 PM
  7. [SOLVED] Counting differences in numbers across columns
    By Ted Metro in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-11-2005, 06:06 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