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!

Like

Formula:

Please Login or Register  to view this content.

in C2 and pulled down?

...

Hi,
The formula is not taking consideration column B, as it also need to match those both criteria.

And how has that been taken into account in your example? 9825A and Security appear only once but you have excluded them?

Try

Formula:

Please Login or Register  to view this content.

( and please don't quote entire posts - use Quick Reply instead)

crossposted: https://www.mrexcel.com/board/thread...umn-b.1146628/

Rule 03: Cross-posting Without Telling Us

Your post does not comply with Rule 3 of our Forum RULES. Do not cross-post your question on multiple forums without telling us about your threads on other forums.

Post a link to any other forums where you have asked the same question.

Cross-posting is when you post the same question in other forums on the web. The last thing you want to do is waste people's time working on an issue you have already resolved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post.

Read this to understand why we ask you to do this.

I have added the crosspost reference for you today. Please comply with this and all our rules in the future