One easy way is to use datafilteradvanced filterunique itemscopy
elsewhere. Record a macro if desired.

--
Don Guillett
SalesAid Software

"simmerdown" wrote in message
...
I have a list of numbers that I want to narrow down to unique numbers....in
other words, I want to delete the row if a number show is already
displayed
elsewhere.

Example list:

1
2
2
2
3
4
4
4

I am searching for a macro that will delete the rows containing the extras
"2's" and "4's".