Producing duplicate values in Column A using Criteria from Column B

[Tgandhi]

Hello all,

I have a desperate question that I need help with, I have been trying to figure this out since past 5 hours. Basically I need to produce list of duplicates in Column A matching both the criteria in column B. If anybody knows how to figure this out please help me.

Excel.PNG

Basically I need to use criteria cash and security both and find the account numbers in column with duplicates having both of those.

Thank you.

[bebo021999]

So you want to list all accounts those have both "Cash" and "Security" in match column?

Try in,i.e, E2:

Please Login or Register  to view this content.

**Array formulas are not entered in the same way as 'standard' formulas. Instead of pressing just ENTER, you first hold down CTRL and SHIFT, and only then press ENTER. If you've done it correctly, you'll notice Excel puts curly brackets {} around the formula (though do not attempt to manually insert these yourself).

Drag down