Selecting the remainder of rows where 2 columns are selected

[DuckmanUS]

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