ExcelBanter - Filter to Duplicate Entries Only

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Filter to Duplicate Entries Only (https://www.excelbanter.com/excel-discussion-misc-queries/184086-filter-duplicate-entries-only.html)

John T Kennedy[_2_]

Filter to Duplicate Entries Only

How can I setup a filter to show me only entries that appear more than once
in a collumn?

Bernie Deitrick

Filter to Duplicate Entries Only

John,

Use a helper column with a formula like

=COUNTIF(A:A,A2)1

Then filter on that column for TRUE values

HTH,
Bernie
MS Excel MVP

"John T Kennedy" wrote in message
...
How can I setup a filter to show me only entries that appear more than once
in a collumn?

John T Kennedy[_2_]

Filter to Duplicate Entries Only

Thanks a bunch!

Grateful,
JTK

"Bernie Deitrick" wrote:

John,

Use a helper column with a formula like

=COUNTIF(A:A,A2)1

Then filter on that column for TRUE values

HTH,
Bernie
MS Excel MVP

"John T Kennedy" wrote in message
...
How can I setup a filter to show me only entries that appear more than once
in a collumn?

All times are GMT +1. The time now is 08:26 AM.