View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
One-Leg One-Leg is offline
external usenet poster
 
Posts: 23
Default Delete rows with duplicate values

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!!!