I am looking for somebody that can help me manipulate some data in an excel sheet.
The attached excel sheet holds data on about 800 companies. I need to eliminate the top and bottom 1% of the last 7 variables (U-AA) (and ofcourse the companies that have a variable that falls into that top and bottom 1 %.)
So select the top and bottom 1% of all the variables and then delete all the companies which have a variable that is in the top and bottom. (You can't do one variable after the other, because this way too many companies will be selected and eliminated)
I besides a working solution I need to know how it is done, because I have several other files that need this aswell.
I have added an explanation to make the requirements a bit more clear.
An explanation is added to make the requirements a bit more clear