View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Peruanos72 Peruanos72 is offline
external usenet poster
 
Posts: 58
Default find/delete row when cell has less than 16 alphanumeric characters

Hello,

How can I find a cell in column "E" that has less than 16 characters and then
delete that row?

Also, is there also a way to find duplicate cells in a column and delete
those rows containing those duplicate cells? Ex: three rows of data are
duplicates so i want to delete 2 of those rows.

Thanks in advance!!!