how do i delete duplicates in a column while still leaving the first
occurence and not delelting other duplicates of another value that are also
on the same column.

US OE Specialty-Real Estate
SUSIX JPMORGAN U.S. REAL ESTATE A
DJ WILSHIRE REIT TR
MORNINGSTAR RANK

US OE Specialty-Real Estate
MUSDX MORGAN STANLEY INST US REAL ESTATE P
DJ Wilshire REIT TR
MORNINGSTAR RANK

I would like to run a function that goes through the worksheet and deletes
US OE Specilty Real Estate after the first occurence while leaving the other
information and deleting a row between the remaining information and while
still keeping the formatting of the remaing rows as well.

See ans in your OTHER post
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"daphoenix" wrote in message
...
how do i delete duplicates in a column while still leaving the first
occurence and not delelting other duplicates of another value that are
also
on the same column.

US OE Specialty-Real Estate
SUSIX JPMORGAN U.S. REAL ESTATE A
DJ WILSHIRE REIT TR
MORNINGSTAR RANK

US OE Specialty-Real Estate
MUSDX MORGAN STANLEY INST US REAL ESTATE P
DJ Wilshire REIT TR
MORNINGSTAR RANK

I would like to run a function that goes through the worksheet and deletes
US OE Specilty Real Estate after the first occurence while leaving the
other
information and deleting a row between the remaining information and while
still keeping the formatting of the remaing rows as well.