+ Reply to Thread
Results 1 to 7 of 7

How to Compare column B values if column A is identical

  1. 02-01-2019, 10:18 PM #1
    ascosmosk166
    ascosmosk166 is offline
    Registered User
    Join Date
    02-01-2019
    Location
    California, USA
    MS-Off Ver
    2013
    Posts
    3

    How to Compare column B values if column A is identical

    I have a list of thousands of customers in column A. Customers can be listed either once or more than once. If a customer is listed more than once, I want to compare their values in column B and make sure that they are consistent. See example below. Sales District for Customer A are not consistent. I would like to identify customers that do not have consistent values in column B. Please help.

    Customer Sales district
    A East
    A East
    A West
    B East
    B West
    B East
    C East
    C East
    D East
    D West
    E West
    E West
    F East
    F East
    G East
    G West
    H West
    H West
    I West
    I East
    J East
    J East
    K West
    K West
    L West
    L East
    M East
    M West
    N East
    N East
    O West
    O East
    P East
    P East
    Q East
    R East
    S East
    S East
    T East
    U East
    U East
    Reply With QuoteRegister To Reply
  2. 02-02-2019, 03:14 AM #2
    FDibbins
    FDibbins is offline
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,938

    Re: How to Compare column B values if column A is identical

    To best describe or illustrate your problem you would be better off attaching a dummy workbook. The workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

    To attach a file to your post,
    click advanced (next to quick post),
    scroll down until you see "manage file",
    click that and select "add files" (top right corner).
    click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

    Once the upload is completed the file name will appear below the input boxes in this window.
    You can then close the window to return to the new post screen.
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford
    Reply With QuoteRegister To Reply
  3. 02-02-2019, 09:45 AM #3
    lordfa9
    lordfa9 is offline
    Forum Contributor
    Join Date
    05-07-2007
    Location
    Singapore
    MS-Off Ver
    2006/2016
    Posts
    170

    Re: How to Compare column B values if column A is identical

    Not sure how many customers you have but the quick and dirty way is to make a pivotable and scan through it

    Hope my MS Paint job can help you

    Then copy the pivot table, paste special values

    Use filtering to remove all items in column A that DO NOT end in Total

    You should get something like:

    Customer A | Subtotal 1

    Customer B | Subtotal 2
    Attached Images Attached Images
    Reply With QuoteRegister To Reply
  4. 02-04-2019, 12:05 PM #4
    ascosmosk166
    ascosmosk166 is offline
    Registered User
    Join Date
    02-01-2019
    Location
    California, USA
    MS-Off Ver
    2013
    Posts
    3

    Re: How to Compare column B values if column A is identical

    Attached is my sample data.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  5. 02-04-2019, 01:17 PM #5
    63falcondude
    63falcondude is offline
    Forum Expert 63falcondude's Avatar
    Join Date
    08-22-2016
    Location
    USA
    MS-Off Ver
    365
    Posts
    6,266

    Re: How to Compare column B values if column A is identical

    Hello and welcome to the forum.

    Try this in C2:

    =IF(COUNTIFS(A:A,A2,B:B,B2)=COUNTIF(A:A,A2),"Match","Not Match")
    Reply With QuoteRegister To Reply
  6. 02-04-2019, 01:50 PM #6
    ascosmosk166
    ascosmosk166 is offline
    Registered User
    Join Date
    02-01-2019
    Location
    California, USA
    MS-Off Ver
    2013
    Posts
    3

    Re: How to Compare column B values if column A is identical

    This worked for me. Thank you very much!
    Reply With QuoteRegister To Reply
  7. 02-04-2019, 01:52 PM #7
    63falcondude
    63falcondude is offline
    Forum Expert 63falcondude's Avatar
    Join Date
    08-22-2016
    Location
    USA
    MS-Off Ver
    365
    Posts
    6,266

    Re: How to Compare column B values if column A is identical

    You're welcome. Happy to help.

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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 for non-identical values in a column
    By majime01 in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 02-25-2017, 12:21 AM
  2. [SOLVED] Find Values in Column A and fill identical values in Column B
    By deviltronics in forum Excel General
    Replies: 6
    Last Post: 10-07-2014, 05:25 PM
  3. [SOLVED] need vba code to compare two column get result of common values of both column
    By breadwinner in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-12-2013, 05:42 AM
  4. Compare values in column a to column b, and put it in column c if they match
    By lesoies in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-26-2013, 07:52 PM
  5. [SOLVED] Compare 4 column values then insert a 5th columns value to a blank column/cell value
    By JasonKMcCoy in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 10-27-2012, 06:01 PM
  6. How to Compare Column 12 to values in column 6 while deleting dups from column 12
    By Launchnet in forum Excel Programming / VBA / Macros
    Replies: 33
    Last Post: 12-16-2011, 03:21 AM
  7. compare 2 sheets on one identical column and update another column
    By ashland in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 10-11-2011, 04:00 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1