How can I filter out rows that have duplicate values in adjacent columns?

Thank you everyone for the input. Very much appreciated.

There are couple of ways to go about this. IF you want to filter the existing table I would suggest that you add a helper column and check for duplicates and filter using that column. There are a few ways to do that. 1) you could (and should ) format that data as a table (home->format as a table) and then in the new column you type "=" and then click on the corresponding cell in column C and then "=" and then click corresponding cell in D. What should be typed is something like: =[@[Value C]] = [@[Value D]]. 2) you could type =C2:C15=D2:D15 and assuming you have Excel 365 you will get a column of True/False. Then you goto to DATA menu and click on the Filter to turn on the quick filters 3) if you don't have excel 365 you type =C2=D2 and then fill down. and again you have to turn on the filters Alternatively you could create a new table showing only the filtered results. Assuming you have excel 365 you could type: =FILTER(A1:D15, (C1:C15=D1:D15)+(ROW(A1:A15)=1)) note that ROW(...)=1 is just to copy/show the header row in the new table. again I would recommend you format the data as a table and use table references so it grows and shrinks with the table you don't have to mess with the formula later on.