Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sum column if multiple criteria are met in adjacent cells | Excel Worksheet Functions | |||
requires that merged cells must be identically sized? | Excel Discussion (Misc queries) | |||
counting cells (COUNTIF) based on two or more criteria | Excel Worksheet Functions | |||
Counting Values that meet another cells criteria | Excel Worksheet Functions | |||
Convert data type of cells to Text,Number,Date and Time | Excel Worksheet Functions |