Delete rows with duplicate values

O

One-Leg

Hello,

I have a list of agents in row A (about 3000) and may of them are duplicate
values (sometimes the same agent name is there 5 or 6 times).

Can I do anything to delete the duplicate rows keeping only one row with the
value in question (formula, macro, etc.)???

Thanks!!!
 

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

Drop down list control value in vba 2
Copying Rows with values in column A pasting in a new doccument and saving that doc 1
Having Blank Cells, etc. ? 1
delete duplicate rows, keep one 1
Combining rows with duplicate names - sum numeric, concatenate str 0
Search cell value in same column 3
Auto duplicate rows 0
remove duplicates but retain one not delete both 4

Top