Hi,

I need a syntax/script for the following scenario,

Example

Column D
Pass
Fail
Not run
Pass
Fail


take the above column with data as example i need to write if the coulmn contain any status as 'Fail' in a seperate column(ex Column E)

Plz let me know script/syntax for this.

Jagan