Conditional Function that filters for duplicates and then filters another set of duplicate

[picklelilly]

Good Morning!

I've got an excel file that contains two sheets

Sheet 1) customer orders and their IP addresses.

Sheet 2) a list of IP addresses that we have flagged in the past as suspicious.

I want to filter the first sheet to show only rows where the IP address shows up at least twice in the first sheet AND matches an IP address from the second sheet.

So basically filter by if there is a duplicate cell in the first sheet and then filter if there is a duplicate cell when comparing the filtered first sheet to the second sheet.

I'm pretty sure this is possible but how is one able to do it?

Thanks!

Sheet One	Name	IP
Order 1	John Doe	123.456.789
Order 2	James Doe	987.654.321
Order 3	Fake Name	123.456.789

Suspicious IP Addresses

548.548.545

123.456.789

[FDibbins]

1, To ID duplicate entries, you could do a COUNTIF() in that column. You could then filter on the COUNTIF column to show > 1
2. You could use Conditional Formatting to color duplicates

When all else failes, please read the yellow banner above and provide a sample WB