Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
delete based on
I have a list
where fields organisation and position In the position the fields are either CC (chairman), CT (treasures) and CS (secretary) what if want is a macro to look up the list. and if the chairman field is there, then delete row CT aND CS and if CC is not there then keep either CT and if CT is not there then keep CS |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Create formula that will pull a value based on text in diff cell? | Excel Discussion (Misc queries) | |||
Delete rows based on multiple criterias | Excel Discussion (Misc queries) | |||
Delete record(s) in other cells based on value of one cell. | Excel Discussion (Misc queries) | |||
How to delete blank rows | Excel Discussion (Misc queries) | |||
Stubborn toolbars in Excel | Excel Discussion (Misc queries) |