| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Easiest way to delete blank cells in column (not entire row) | Excel Discussion (Misc queries) | |||
| How do I delete duplicate records from an entire Excel workbook? | Excel Discussion (Misc queries) | |||
| Delete ENTIRE row after updating info in worksheet. | Excel Worksheet Functions | |||
| can I delete entire row if adjacent cell formats differ? | Excel Worksheet Functions | |||
| how do I delete all rows that match a condition? | Excel Worksheet Functions | |||
Threaded Mode
