I gang

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

Færdigheder: 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, working excel, manipulate excel data, sheet excel, files excel, sheet can 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 for 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 Mere

$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