View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Christine
 
Posts: n/a
Default Can I delete an entire row if condition is not met?

Hi Bob,

There's no 'contain' in the filter option, only have Excel 2000 so maybe
that's for the future ... when my Word and Outlook are compatible again, I
assume.

Whata function do you use for that? Just had a look in help and can't find
anything.
Here's a bigger sample and I want to have the 'ProductLaunch' people staying:

Diary;ProductLaunch;private;xmas
Diary;ProductLaunch;private
Diary;ProductLaunch
ProductLaunch;Diary;private
Diary;ProductLaunch
Diary;ProductLaunch
Diary;ProductLaunch;xmas
Diary;ProductLaunch;private;xmas
xmas
Calendar;public;Newsletter;xmas
public;Newsletter
xmas;Newsletter
NPS 2006;Newsletter
CT User;DiaryT;public
xmas;public;Newsletter
CT User;DiaryT;private
CT User;DiaryT;public
CT User;VIP;public
CT User;NPS 2006;public;VIP;xmas
xmas;VCT;CT User;CT;DiaryT;NPS 2006;public;Newsletter
CT User;DiaryT;public
CT User;DiaryT;public
xmas;CT User;VIP;DiaryT;NPS 2006;private;Newsletter
CT User;DiaryT;private
CT User;DiaryT;private;Newsletter
CT User;DiaryT;private
CT User;DiaryT;private
CT User;DiaryT;private
xmas;CT User;DiaryT;private;Newsletter

Thanks for your help!