Filtering out column values that don't repeat

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a way to filter out all the values in a column that only appear
once, leaving just items that appear 2+ times? I know there's a way to get
rid of duplicates, but I haven't been able to find a feature that would do
the opposite. Thank you for your insight!
 
Using SubQueries try something like

SELECT T1.*
FROM TableName As T1
WHERE T1.FieldName In (SELECT T2.FieldName
FROM TableName As T2
GROUP BY T2.FieldName
HAVING Count(T2.FieldName)>=2)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Filtering out single values (keeping only repeating data) 3
Filtering out single values (keeping duplicates) 2
Excel Comparing two columns 1
Macro to copy value in field and insert it into filter 2
Problems with the Criteria field 2
Query Criteria Not Working 2
Excel Macro for deleting Rows containing dates greater than "today" 0
Crosstable filtering 2

Back
Top