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" wrote in message
...
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" wrote in message
...
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