exclude cells with certain criteria

B

Bram

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
 
B

Bob Phillips

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

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top