CODEWITHSUNDEEP
excelexcel-formula
LiquidMusic1
LiquidMusic1

Reputation: 55

Display only if data item exists 3 or more times

I have a large excel file with phone numbers listed in one of the columns. In that column, I would like to filter the results for the phone numbers that show up 3 or more times. I don't want any of the other data in the excel file to disappear either.

So far, I have tried Conditional Formatting. However, I didn't get very far because the only formula that I could think to use would be "countif" and that's based on pre-defined criteria, whereas I have 30,000 different phone numbers listed here and I need to only highlight the items that show up 3 or more times.

Please help me?

Upvotes: 0

Views: 1506

Answers (1)

CRUTER
CRUTER

Reputation: 866

Add column 'Count' and use the COUNTIF() function like this (see below)... Then filter.

Phone Number List Count using COUNTIF Function

Hope this helps!

Upvotes: 1

Related Questions