Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to Delete entire rows by selecting different text in column A
I have a database that exports data to excel where duplicate and specific
data is deleted using macros. My question is the data in column A uses multiple years of information. Example 2009 2 Man Fall Senior Team Beall 2009 2 Man Fall Senior Team Beeghly 2008 2 Man Fall Senior Team Berish 2009 2 Man Fall Senior Team Blohm 2008 2 Man Fall Senior Team Brander 2008 2 Man Fall Senior Team Brown Using the If function how do I either just use part of the cell, e.g. "Fall Senior" or use the entire cell e.g. 2008 2 Man Fall Senior Team but use a wild card character for the year e.g. 20?? 2 Man Fall Senior Team to delete the entire row? Any help would be appreciated. -- Doug Small Business Databases |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I delete blank rows from excel without selecting them? | Excel Worksheet Functions | |||
Keyboard shortcut or selecting entire column | Excel Worksheet Functions | |||
CANNOT DELETE AN ENTIRE COLUMN | Excel Discussion (Misc queries) | |||
Hide/Delete entire rows based in the content of one cell | Excel Discussion (Misc queries) | |||
Delete all rows where Column A contains Text | Excel Worksheet Functions |