Results 1 to 8 of 8

Finding Duplicate accounts in column A matching criteria column B

Threaded View

  1. #1
    Registered User
    Join Date
    07-27-2020
    Location
    toronto
    MS-Off Ver
    2016
    Posts
    7

    Finding Duplicate accounts in column A matching criteria column B

    Hello all,

    I have tried several formulas and ways but none works for me. Basically I need to find the list of accounts ( I am dealing with 10000 rows on daily basis) that are duplicate matching 2 criteria's from column B. So what I need help is to get a formula that basically highlights or produce unique value like "yes" or "1" so that I can apply maybe color filter and work on the rest of data on the sheet.

    For e.g. on the attached excel sheet accounts 1324A, 1653C, 9825A are repeated multiple times, now using the criteria cash and security from column B I need to get a list that shows only accounts that are repeated ( but I need the list in this case 1234A is repeated 3 times so I need something that produces those account list) so that I can exclude them.



    If you look at the snip, accounts: 1678B, 7894A and 5654B are the only accounts I need to work on for the daily basis.
    For accounts 7894A and 5654B accounts are repeated in column A but because it does not have both cash & security in column B, I can work on the data.


    I have included the snip of the way the result should appear and also the spreadsheet. Any help will be greatly appreciated!
    Attached Images Attached Images
    Attached Files Attached Files
    Last edited by Tgandhi; 09-24-2020 at 12:32 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Counting Column B entries, excluding duplicate criteria in column A.
    By jakiechan in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-20-2020, 10:59 AM
  2. Subtract values from Column B but only when matching criteria in Column A
    By dtpunshon in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-12-2020, 06:25 AM
  3. Finding lowest in column after matching data in another column
    By tiempo1976 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-10-2017, 01:22 PM
  4. [SOLVED] Matching Debits and Credits in one column with Vendor Criteria from another column
    By jhm5139 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 06-24-2016, 03:03 PM
  5. Finding Matching Data in one Column/Adding corresponding matching string value.
    By swade730 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-02-2013, 07:23 PM
  6. [SOLVED] Count text in one column Matching single or multiple Criteria from Other Column Excel 2003
    By Jose Macieira in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 07-17-2013, 06:55 AM
  7. Finding duplicate accounts using formula instead of filtering
    By Matt Parsons in forum Excel General
    Replies: 5
    Last Post: 03-25-2011, 01:45 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