delete a duplicate in column while leaving other duplicates

D

daphoenix

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.
 

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


Top