Dear,

For my thesis i need to filter a number of S&P500 companies over the last 12 years.
In the list you can see a year, a company name and the CEO-compensation.
But i only need the companies from who I have data every single year.

So my question is the following:

How can i filter my document so that it only reveals the companies who are listed every single year from the year 1995 up until 2007?

If you want to c the document:

http://www.MegaShare.com/3222931

Password: thesis



Thank you!