Færdiggjort

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!

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

Evner: Excel

Se mere: Need help in excel, me excel, i need help with excel, i need excel help, need help with excel, need excel help, sheet, EXCEL SHEET , excel sheet an, excel 7, excel manipulate data, can help, excel delete, excel 2011, need excel sheet, excel attached, aa files, companies excel sheet, excel companies, variable excel

Om arbejdsgiveren:
( 9 bedømmelser ) Zoetermeer, Netherlands

Projekt ID: #1117441

Tildelt til:

DrTech76

Hi!

$30 USD in 0 dage
(23 bedømmelser)
4.6

13 freelancere byder i gennemsnit $48 på dette job

imudita

Please see my PM

$30 USD på 1 dag
(26 bedømmelser)
4.6
sergey2511

hello, please check PM for possible solution

$35 USD in 0 dage
(9 bedømmelser)
3.9
jcvelina

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

$30 USD in 0 dage
(3 bedømmelser)
3.6
workonline8050

pls check my PM. thank you.

$50 USD in 5 dage
(3 bedømmelser)
3.4
dobreiiita

Ready to work Check PM>>

$30 USD på 1 dag
(5 bedømmelser)
2.6
kanadyanako

For your consideration.

$30 USD på 1 dag
(1 bedømmelse)
1.8
Ratsclip

Let me help! See my PM.

$40 USD in 2 dage
(1 bedømmelse)
1.2
coder171

ready to wrok

$50 USD på 1 dag
(0 bedømmelser)
0.0
chichuphy

---Check Pm for details----

$40 USD in 0 dage
(0 bedømmelser)
0.0
ltovander

I can get this done.

$175 USD in 5 dage
(0 bedømmelser)
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 Flere

$55 USD in 2 dage
(0 bedømmelser)
0.0
RupalHardaha

Please check the PM.

$30 USD på 1 dag
(0 bedømmelser)
0.0