Matching rows.

[ylafont]

Forgive me if this has been request before, any assistance is greatly appreciate.

I have the data below consisting of thousands of rows. I need to isolate rows only where the field1 and field2 columns match. is there a quick method of performing this in excel?

FileID1​	FileID2​	Hash​
27468​	27462​	8BEA348CA9301F6459F8E8A2DD126D7C​
29874​	29843​	EEFFBC24EAE3F4FD5ED5232993081A36​
31150​	31126​	AE3675DC487DEF0F9C9FEC42B81B1438​
32330​	32330​	59D77968DB2FE6AFE42EEC21268F3D5A​
33218​	33211​	9231697E3A859F0D2C4E39AFB1C4AFFE​
33984​	33980​	3B20A501EB17BA2A6FA6A43D9A3D70BA​
35275​	35260​	201D7B2CE5E1DB924CAEDC0F7DA93489​
35402​	35402​	726C1DEE00F5D17EAB39B3DD1AE4EC0E​
35887​	35883​	176C07CD85BDD52449073310B9177977​
36734​	36657​	2CDECE0B8C581D9E0F68B8BC3CEDAAB9​
36924​	36912​	94BF549976E42D891F59A66C9972992E​

<colgroup><col span="2" style="margin-left: 40px;"><col style="margin-left: 40px;"></colgroup><tbody>
</tbody>

Thank you in advance.

 

[ylafont]

BTW

I know that i can use something like =IF(A485=B485,C485:C485,"") but wanted something more refined where i did not have to copy the data as text and then sort.

 

[FDibbins]

See if using a helper column and Filters will help?

	A​	B​	C​	D​
1​	FileID1	FileID2	Hash	Helper
2​	27468​	27462​	8BEA348CA9301F6459F8E8A2DD126D7C	FALSE​
3​	29874​	29843​	EEFFBC24EAE3F4FD5ED5232993081A36	FALSE​
4​	31150​	31126​	AE3675DC487DEF0F9C9FEC42B81B1438	FALSE​
5​	32330​	32330​	59D77968DB2FE6AFE42EEC21268F3D5A	TRUE​
6​	33218​	33211​	9231697E3A859F0D2C4E39AFB1C4AFFE	FALSE​
7​	33984​	33980​	3B20A501EB17BA2A6FA6A43D9A3D70BA	FALSE​
8​	35275​	35260​	201D7B2CE5E1DB924CAEDC0F7DA93489	FALSE​
9​	35402​	35402​	726C1DEE00F5D17EAB39B3DD1AE4EC0E	TRUE​
10​	35887​	35883​	176C07CD85BDD52449073310B9177977	FALSE​
11​	36734​	36657​	2CDECE0B8C581D9E0F68B8BC3CEDAAB9	FALSE​
12​	36924​	36912​	94BF549976E42D891F59A66C9972992E	FALSE​

Column D is the helper
D2=ISNUMBER(MATCH(A2,B2:B12,0))
copied down

Then, apply filters, and filter on TRUE

 

[Fluff]

You could use Cf
Select your 2 columns > Home tab > Conditional formatting > new rule > Format only unique or duplicate values.
Then select the format you want