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?

[TABLE="width: 383"]
<colgroup><col span="2" style="margin-left: 40px;"><col style="margin-left: 40px;"></colgroup><tbody>[TR]
[TD]

FileID1​

[/TD]
[TD]

FileID2​

[/TD]
[TD]

Hash​

[/TD]
[/TR]
[TR]
[TD]

27468​

[/TD]
[TD]

27462​

[/TD]
[TD]

8BEA348CA9301F6459F8E8A2DD126D7C​

[/TD]
[/TR]
[TR]
[TD]

29874​

[/TD]
[TD]

29843​

[/TD]
[TD]

EEFFBC24EAE3F4FD5ED5232993081A36​

[/TD]
[/TR]
[TR]
[TD]

31150​

[/TD]
[TD]

31126​

[/TD]
[TD]

AE3675DC487DEF0F9C9FEC42B81B1438​

[/TD]
[/TR]
[TR]
[TD]

32330​

[/TD]
[TD]

32330​

[/TD]
[TD]

59D77968DB2FE6AFE42EEC21268F3D5A​

[/TD]
[/TR]
[TR]
[TD]

33218​

[/TD]
[TD]

33211​

[/TD]
[TD]

9231697E3A859F0D2C4E39AFB1C4AFFE​

[/TD]
[/TR]
[TR]
[TD]

33984​

[/TD]
[TD]

33980​

[/TD]
[TD]

3B20A501EB17BA2A6FA6A43D9A3D70BA​

[/TD]
[/TR]
[TR]
[TD]

35275​

[/TD]
[TD]

35260​

[/TD]
[TD]

201D7B2CE5E1DB924CAEDC0F7DA93489​

[/TD]
[/TR]
[TR]
[TD]

35402​

[/TD]
[TD]

35402​

[/TD]
[TD]

726C1DEE00F5D17EAB39B3DD1AE4EC0E​

[/TD]
[/TR]
[TR]
[TD]

35887​

[/TD]
[TD]

35883​

[/TD]
[TD]

176C07CD85BDD52449073310B9177977​

[/TD]
[/TR]
[TR]
[TD]

36734​

[/TD]
[TD]

36657​

[/TD]
[TD]

2CDECE0B8C581D9E0F68B8BC3CEDAAB9​

[/TD]
[/TR]
[TR]
[TD]

36924​

[/TD]
[TD]

36912​

[/TD]
[TD]

94BF549976E42D891F59A66C9972992E​

[/TD]
[/TR]
</tbody>[/TABLE]


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?
[Table="width:, class:grid"][tr][td] [/td][td]

A​

[/td][td]

B​

[/td][td]

C​

[/td][td]

D​

[/td][/tr]
[tr][td]

1​

[/td][td]FileID1[/td][td]FileID2[/td][td]Hash[/td][td]Helper[/td][/tr]

[tr][td]

2​

[/td][td]

27468​

[/td][td]

27462​

[/td][td]8BEA348CA9301F6459F8E8A2DD126D7C[/td][td]

FALSE​

[/td][/tr]

[tr][td]

3​

[/td][td]

29874​

[/td][td]

29843​

[/td][td]EEFFBC24EAE3F4FD5ED5232993081A36[/td][td]

FALSE​

[/td][/tr]

[tr][td]

4​

[/td][td]

31150​

[/td][td]

31126​

[/td][td]AE3675DC487DEF0F9C9FEC42B81B1438[/td][td]

FALSE​

[/td][/tr]

[tr][td]

5​

[/td][td]

32330​

[/td][td]

32330​

[/td][td]59D77968DB2FE6AFE42EEC21268F3D5A[/td][td]

TRUE​

[/td][/tr]

[tr][td]

6​

[/td][td]

33218​

[/td][td]

33211​

[/td][td]9231697E3A859F0D2C4E39AFB1C4AFFE[/td][td]

FALSE​

[/td][/tr]

[tr][td]

7​

[/td][td]

33984​

[/td][td]

33980​

[/td][td]3B20A501EB17BA2A6FA6A43D9A3D70BA[/td][td]

FALSE​

[/td][/tr]

[tr][td]

8​

[/td][td]

35275​

[/td][td]

35260​

[/td][td]201D7B2CE5E1DB924CAEDC0F7DA93489[/td][td]

FALSE​

[/td][/tr]

[tr][td]

9​

[/td][td]

35402​

[/td][td]

35402​

[/td][td]726C1DEE00F5D17EAB39B3DD1AE4EC0E[/td][td]

TRUE​

[/td][/tr]

[tr][td]

10​

[/td][td]

35887​

[/td][td]

35883​

[/td][td]176C07CD85BDD52449073310B9177977[/td][td]

FALSE​

[/td][/tr]

[tr][td]

11​

[/td][td]

36734​

[/td][td]

36657​

[/td][td]2CDECE0B8C581D9E0F68B8BC3CEDAAB9[/td][td]

FALSE​

[/td][/tr]

[tr][td]

12​

[/td][td]

36924​

[/td][td]

36912​

[/td][td]94BF549976E42D891F59A66C9972992E[/td][td]

FALSE​

[/td][/tr]
[/table]
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