exclude cells with certain criteria

I have a large dataset (over 20,000 rows) with monthly performance of
certain companies.
column A is the date (A1-A12 january-december for company x; A13-A24
january-december for company y etc.)
Column B is the company name(B1-b12 company name x; B13-B24 company name y
etc.)
Column C is the monthly performance. e.g. c1 is performance of January of
company x C2 is performance of February of company x, c13 is performance of
January of company y and so on

Some companies only reported performance for the months (e.g.) March till
december. I want to exclude those companies that didn't report performance
during a whole year.

thank and regards,

Bram

Exclude from what? Presumably you have some formula evaluation. It would
help to know what that is.

--
HTH

Bob Phillips

"Bram" <Bram@discussions.microsoft.com> wrote in message
news:B17F4249-D236-4E65-8358-55BB519E85D4@microsoft.com...
> I have a large dataset (over 20,000 rows) with monthly performance of
> certain companies.
> column A is the date (A1-A12 january-december for company x; A13-A24
> january-december for company y etc.)
> Column B is the company name(B1-b12 company name x; B13-B24 company name y
> etc.)
> Column C is the monthly performance. e.g. c1 is performance of January of
> company x C2 is performance of February of company x, c13 is performance
of
> January of company y and so on
>
> Some companies only reported performance for the months (e.g.) March till
> december. I want to exclude those companies that didn't report performance
> during a whole year.
>
> thank and regards,
>
> Bram

I want to make some calculations with the data of companies that reported
their company performance for a whole year. That is companies that reported
performance only for a couple of months of the year must be deleted from the
dataset. I hope this makes it clear.

"Bob Phillips" wrote:

> Exclude from what? Presumably you have some formula evaluation. It would
> help to know what that is.
>
> --
> HTH
>
> Bob Phillips
>
> "Bram" <Bram@discussions.microsoft.com> wrote in message
> news:B17F4249-D236-4E65-8358-55BB519E85D4@microsoft.com...
> > I have a large dataset (over 20,000 rows) with monthly performance of
> > certain companies.
> > column A is the date (A1-A12 january-december for company x; A13-A24
> > january-december for company y etc.)
> > Column B is the company name(B1-b12 company name x; B13-B24 company name y
> > etc.)
> > Column C is the monthly performance. e.g. c1 is performance of January of
> > company x C2 is performance of February of company x, c13 is performance
> of
> > January of company y and so on
> >
> > Some companies only reported performance for the months (e.g.) March till
> > december. I want to exclude those companies that didn't report performance
> > during a whole year.
> >
> > thank and regards,
> >
> > Bram
>
>
>