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

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?

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?