Selecting the remainder of rows where 2 columns are selected

I'm a total Excel newb and need help doing something I suspect is very easy for someone that knows what they are doing. I'm taking a huge number of rows and finding duplicates and simply (I hope) to just C&P them into a new sheet.

I have a set of spreadsheets I have to go through and find duplicates. I didn't know where to start so I searched around and found "Ablebits" The information in columns A and B are the where necessary info is for finding the duplicates that I'm looking for. Ablebits did find the duplicates and I chose for "Selecting" the information instead of highlighting.

Now that I have the duplicates selected (Either A or B or both qualifies a duplicate on a row, most are both with a few exceptions) I need to now figure out how to select the rest of the various column info in the selected rows. I can't do it manually because this is roughly 1 million rows I need to go through.

Is there some equation or way to select the rest of the info in the selected rows?

The way these sheets are setup I have A through M and Ablebits has already found the duplicates in A and/or B. The reason that only 1 column is selected on rare occasions is further down the sheet that info is a match. Normally it's both A and B though.

Is there and easier way to find duplicates? Ablebits is working fine and it's very fast so I tend to like this method of finding the duplicate info in those two columns I just can't seem to figure out how to complete selecting the rest of the info on each selected row so I can copy then paste all of this into a new spreadsheet. I know this is a repeat basically of what I posted above but I'm just trying to be thorough.

I included a sample to show you what I'm talking about.


Appreciate any help!

Regards

Tim

That did work but I have to copy only the TRUE's so I can paste them in a new sheet. In the end I need a separate copy of all of the duplicates. How can I do this? I didn't even know how to do your formula so I got a little help lol. Anyone know how I can do this part? I really appreciate it!

Also, How can I drag that formula down without having to hold it below the bottom border? Each sheet has approx 50K rows so It takes a long time to drag it to the bottom. Is there way to drag it down so it does it quickly to the last entry on the page or is that the only way to do it?

Copy and paste the formula from post #3 into cell N2, hit Enter, then double-click the bottom right corner of the cell with the formula in it (cell N2) that you use to drag it down, to automatically drag the formula down column N.

Now filtering column N to show only TRUE's, you can then copy/paste only the TRUE's into a new sheet, thus only showing duplicates in that new sheet.