Greetings,

We have excel sheets created everday for some tasks. There are 2
columns that are getting filled manually.

ColumnA: Filled with either SUCCESS, FAIL or OTHER
ColumnB: If the columnA is filled with either FAIL or OTHER, then we
are filling
column B with some reason for these values. So in short, if ColumnA's
value is either FAIL or OTHER, then ColumnB should NOT BE NULL.

I am looking for a script in excel (macro or something) or a report
that should tell me records(may be in a mail or any text file...)
which have FAIL or OTHER in column A but column B is empty and the no
of records matching this criteria.

Is there a way to achieve this using some code in excel? Also, I have
to make sure that ColumnA should not be having any values other than
SUCCESS, FAIL or OTHER.

For now, we are doing this manually. But we have lot of excel files
and each one has pretty big data. I want to achieve this using a code
in excel to avoid manual work.

Can anyone please advise.

TIA