Sorting duplicates

nadineg207 

One approach is to use a pivot table. 

Select any cell in your data range and use Insert>Pivot Table

Drag "Phone" to the Rows area, "talk time" and "queue time" to the Filters area and "Phone" to the Values area.

Now right-click anywhere in the "Sum of phone" column and select "Summarize values by" and "Count":

Now filter the "talk time" filter by "00:00:00" (or whatever is appropriate in your data):

Now apply a filter to "Queue time" to select all non-blank items. You should check "Select multiple items" then un-check the blank item in the filter. Please also scroll to the bottom of the list of items to check there isn't anything else you want to exclude.

Now click the filter drop-down next to the text "Row Labels" and select "Values filters", then "Greater than":

Filter where Count of Phone is greater than 1. This effectively returns those phone numbers who appear more than once in the source data:

These steps should give you what you want. 

There are of course other formula-based methods, but this is probably easiest. 

Let me know how you get on!

Cheers

Owen