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