How do I show only the items where they are NOT repeated in the column?

Hi
Several possibilities. One manual process could be:

Say your data is in A1:A100
1. Create a list of distinct items in column D
- select A1:A100
- menu Data > Filter > Advanced Filter
   -  Action: Copy To Another Location
   - Copy To: $D$1
   - Unique Records Only: Checked
You get a list of unique items in column D
2. Evaluate Singles and Multiples
- in E1 enter the formula: =IF(COUNTIF($D$1:$D$100,E1)>1, "Multiple","Single")
- copy/paste E1 down along the range of values
3. Groups the 2 groups
- Select D:E
- Sort (menu Data > Sort) based on E then D

I hope this helps,
Sebastien

And here are 3 macros that just hide the rows you want hidden depending on which macro you run.  1 hides dupes... 1 shows only dupes, and 1 unhides everything.  The disadvantage to this is it hides the entire row, not just the column that your list is in...


Sub HideDupes()
Dim r As Range
Dim MyVal
Cells.EntireRow.Hidden = False
Set r = Range("A1") 'Change this to the first cell in the list
    Do Until r.Row > Range("A65536").End(xlUp).Row 'Change A to the column with your list in it
        If r.Offset(1, 0).Value = r.Value Then
            MyVal = r.Value
            Do Until r.Value <> MyVal
                Set r = r.Offset(1, 0)
                r.Offset(-1, 0).EntireRow.Hidden = True
            Loop
        Else
            Set r = r.Offset(1, 0)
        End If
    Loop
End Sub



Sub ShowDupesOnly()
Dim r As Range
Dim MyVal
Cells.EntireRow.Hidden = False
Set r = Range("A1") 'First cell in list
    Do Until r.Row > Range("A65536").End(xlUp).Row 'Change A to the column with your list in it
        If r.Offset(1, 0).Value = r.Value Then
            MyVal = r.Value
            Do Until r.Value <> MyVal
                Set r = r.Offset(1, 0)
            Loop
        Else
            Set r = r.Offset(1, 0)
            r.Offset(-1, 0).EntireRow.Hidden = True
        End If
nxt:
    Loop
End Sub



Sub UnhideAll()
    Cells.EntireRow.Hidden = False
End Sub



:-)
ah

You also might think of using conditional formating.
Asuminig the range is from Cell A1 to A10
1. select cell A1 and select from menu: Format>>Conditional Formatting
2. Now set the condtion on Formula
3. enter the following formula to get the numbers which are duplicate:
=COUNTIF(A$1:A$10,A1)>1
4. also set the formating pattern
5. now for the items which are not duplicate you add a new condition and use the following formula: =COUNTIF(A$1:A$10,A1)=1
6. also set here the formatting you like.
If this is done then:
7. copy the cell
8. select all other cells and use: Edit>>Paste Special>.Formating

now it should represent the results

If you don't want this you might add an addition column
and fill in that column the following formula: =COUNTIF(A$1:A$10,A1)>1

draq this column downwards. It now shows TRUE or FALSE.
Using the Autofilter option in the menu: Data you can select to show only the true or the false items

I hope this works for you
regards,
Jeroen