Extract only the duplicates records

[GerryZucca]

Hello Excel's friends
I'm learning Excel formula, and in this case i'm trying to Extract only the duplicates records (but not unique list of dups)
You will understand better rom the workbook attached
Thanks for the Help

[mikeava]

Hi - do you need a formula? Can't you use Conditional Formatting?

Highlight Rows A and B
On the Home Tab click Conditional Formatting
Select Highlight Cell Rules then Duplicate Values
In the Values with box - click the drop-down bar to choose how you want it formatted
Click OK

Then you can Filter
And Filter by Color and choose the color you selected.

[GerryZucca]

Hello Mike, thank you for the answer but I am learning arrays formula thank you for the help

[bluesky63]

Gerry,

Using Power Query is quite easy to achieve too

Please Login or Register  to view this content.

[GerryZucca]

Hello Bluesky63
thank you for the answer, but im learning array formula
I hope some one can helpme
Thank you

[GerryZucca]

guys I made the example simpler, look in the attachment, now there is only one column .. thanks for the help

[Bo_Ry]

Please try at D3 wjth Array enter

Please Login or Register  to view this content.

Or countif

=IFERROR(INDEX(A$3:A$12,AGGREGATE(15,6,ROW($A$3:$A$12)/(COUNTIFS($A$3:$A$12,$A$3:$A$12,$B$3:$B$12,$B$3:$B$12)>1),ROWS(D$3:D3))-ROW($A$2)),"")

[bluesky63]

Hi Gerry,

another method for unique list from multiple columns

Go to F2, copy down the following

Please Login or Register  to view this content.

[GerryZucca]

Thank you everybody
i love th 1st Bo_Ry solution, because I like FREQUENCY Function
Thank you so much everybody for you teach
Greatings Gerry