In Progress

Help with excel sheet

Hi,

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.

Greetings!

Skills: Excel

See more: me excel, need excel help, sheet, excel 7, excel manipulate data, can help, excel delete, excel 2011, need excel sheet, excel attached, files, companies excel sheet, excel companies, variable excel, working excel, manipulate excel data, files excel, sheet excel, excel sheet data, help excel, looking excel files, excel help label format, seller net sheet excel, code update sheet excel, format salary sheet excel

About the Employer:
( 9 reviews ) Zoetermeer, Netherlands

Project ID: #1117441

Awarded to:

DrTech76

Hi!

$30 USD in 0 days
(23 Reviews)
4.6

13 freelancers are bidding on average $48 for this job

imudita

Please see my PM

$30 USD in 1 day
(26 Reviews)
4.6
sergey2511

hello, please check PM for possible solution

$35 USD in 0 days
(9 Reviews)
3.9
jcvelina

Hi, Excited to bid and work on more Excel projects. Please see PMB

$30 USD in 0 days
(3 Reviews)
3.6
workonline8050

pls check my PM. thank you.

$50 USD in 5 days
(3 Reviews)
3.4
dobreiiita

Ready to work Check PM>>

$30 USD in 1 day
(5 Reviews)
2.6
kanadyanako

For your consideration.

$30 USD in 1 day
(1 Review)
1.8
Ratsclip

Let me help! See my PM.

$40 USD in 2 days
(1 Review)
1.2
coder171

ready to wrok

$50 USD in 1 day
(0 Reviews)
0.0
chichuphy

---Check Pm for details----

$40 USD in 0 days
(0 Reviews)
0.0
ltovander

I can get this done.

$175 USD in 5 days
(0 Reviews)
0.0
raviparashar12

Hi, i am excel professional working in a mnc. it can be done easily, but we need to have a chat before to know , what exactly you want, cause i am not much clear with the you wrote. lets have a discussion and go for More

$55 USD in 2 days
(0 Reviews)
0.0
RupalHardaha

Please check the PM.

$30 USD in 1 day
(0 Reviews)
0.0