Select the cells needed to compare. step1 - Home > Conditional Formatting > Highlight Cell Rules > Duplicate Values (set any color) with selected cells go Data > Filter go to column filter button > Filter by Color and choose the color from step1
