How can I setup a filter to show me only entries that appear more than once in a collumn?
J John T Kennedy Apr 17, 2008 #1 How can I setup a filter to show me only entries that appear more than once in a collumn?
B Bernie Deitrick Apr 17, 2008 #2 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, 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
J John T Kennedy Apr 17, 2008 #3 Thanks a bunch! Grateful, JTK Bernie Deitrick said: 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 Click to expand...
Thanks a bunch! Grateful, JTK Bernie Deitrick said: 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 Click to expand...