Conditional Delete

[odrisso]

Hi,

I have the following table:

[TABLE="class: cms_table_cms_table, width: 341"]
<tbody>[TR]
[TD]SN[/TD]
[TD][/TD]
[TD]'Stage 2'[/TD]
[/TR]
[TR]
[TD]SN[/TD]
[TD][/TD]
[TD]'Stage 2'[/TD]
[/TR]
[TR]
[TD]Ex[/TD]
[TD][/TD]
[TD]'Stage 1'[/TD]
[/TR]
[TR]
[TD]SN[/TD]
[TD][/TD]
[TD]'Stage 2'[/TD]
[/TR]
[TR]
[TD]Ex[/TD]
[TD][/TD]
[TD]'Stage 2'[/TD]
[/TR]
[TR]
[TD]SN[/TD]
[TD][/TD]
[TD]'Stage 2'[/TD]
[/TR]
[TR]
[TD]SN[/TD]
[TD][/TD]
[TD]'Stage 2'[/TD]
[/TR]
[TR]
[TD]Ex[/TD]
[TD][/TD]
[TD]'Stage 2'[/TD]
[/TR]
[TR]
[TD]SN[/TD]
[TD][/TD]
[TD]'Stage 2'[/TD]
[/TR]
[TR]
[TD]Ex[/TD]
[TD][/TD]
[TD]'Stage 3'[/TD]
[/TR]
[TR]
[TD]SN[/TD]
[TD][/TD]
[TD]'Stage 2'[/TD]
[/TR]
[TR]
[TD]SN[/TD]
[TD][/TD]
[TD]'Stage 2'[/TD]
[/TR]
[TR]
[TD]SN[/TD]
[TD][/TD]
[TD]'Stage 2'[/TD]
[/TR]
</tbody>[/TABLE]



Now, I want to delete the texts (Stage 1 , Stage 2 and Stage 3) from 3rd column where there is an Ex. I actually want to delete anything where I encountered with an Ex.

Please let me know the formula behind it.

 

[abmati]

You can do this manually by using the formula as under in additional column:
We consider these columns as "A", "B" and "C". We use column "D" for formula:
D1=IF(A1="Ex","",C1) and copy it to down rows.
Then copy the data of "D" column, paste it as value and delete column "C".