View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Radhakant Panigrahi Radhakant Panigrahi is offline
external usenet poster
 
Posts: 45
Default Deleting Rows on the basis of cell comment

Hi,

i need to delete the rows where the comment in the column A contains some
charaters...for example below are the comment in column A...and i need to
delete the rows where the comment in column A is BE, IE and AT. Is there any
formula by which the rows with BE, IE and AT in column A can be deleted...

DE
DE
IT
IT
PT
PT
IE
BE
IT
BE
AT

rgds
radha