HElp regarding script !!

[nikhilgarg]

Hey,

In my application,

I have 2 different excel sheets.

In one sheet all that time is mentioned at which server is down

In second sheet a planned time is mentioned.

Now i want a column to be shown which shows planned or unplanned downtime matching timimg in both sheets.

But unplanned downtime is shown everywhere.

What to do ??

Thanks

[nikhilgarg]

HEy,

Thanks. It works.

But why have you used Trim function in :

Trim(PurgeChar(Event,'')) as Event

Thanks.