Help finding duplicates

Sample - Copy.xlsx

Hi all, I'm using Excel 2013, I have a table that has 116,000 rows , The first Column is repeated numbers for wells, the second column is months of production. Now my problem is that there is 2600 months that is repeated for the same well numbers. How would I highlight them or copy them to a different file?
For example in the next table, I'm trying to find a function to find the bold cells , please note that the letters are the first column and the numbers are the second column.

A 1
A 2
A 3
A 3
A 4
B 1
B 2
B 3
B 4
B 4
C 1
C 1
C 2
C 2
C 3
Thank you very much for any help!

Hi,

Would you upload the workbook and manually add the results you expect clearly identifying which cells are results.
There is a contradiction in your question

"The first Column is unique numbers" & "please note that the letters are the first column"

I would use concatenate and then remove duplicates function on the column I concatenated.



Edit: oops, read that wrong. I thought you wanted them deleted.

If where you show bold the whole row is bold, then you can use the Find and Select. In the Find, leave the Find What blank and click on Format (down diamond) and select BOLD from the font options. Click FIND ALL.

A small window will open with all the items that were found. Select all in that window using Ctrl + A all the bold font in the worksheet will be selected. Close the Find and Select dialogue and before doing anything else Ctrl + C to copy the selected areas.

Create a new worksheet within the same workbook and Paste. Only the Bold entries will be pasted. If you try to copy directly to another workbook, the whole range is copied and not just the selected area copied. Export the new worksheet to the new workbook by right clicking the tab of the new worksheet and click on Move or Copy....follow the prompts.

Based on your sample, try this.

In C1, copied down...
=COUNTIFS($A$1:$A$61,A1,$B$1:$B$61,B1)

Then you could apply filters and uncheck "1", you would be left with all the duplicates. You can then either copy them elsewhere, delete them or do what you want.

If you want to keep 1 of the duplicates and just show all the 2nd, 3rd duplicates etc, then change the formula to...
=COUNTIFS($A$1:A1,A1,$B$1:B1,B1)

Originally Posted by FDibbins

Based on your sample, try this.

In C1, copied down...
=COUNTIFS($A$1:$A$61,A1,$B$1:$B$61,B1)

Then you could apply filters and uncheck "1", you would be left with all the duplicates. You can then either copy them elsewhere, delete them or do what you want.

If you want to keep 1 of the duplicates and just show all the 2nd, 3rd duplicates etc, then change the formula to...
=COUNTIFS($A$1:A1,A1,$B$1:B1,B1)

It worked like a dream, Thank you very much. You are awesome.

Happy to help